Copy a column of data from one excel file to another file..

Question

Hi..

I am a newbie in writing macros.

I have an excel file in which a column (total hours) is present.

As I update the 'total hours' column I need those values to be reflected in another excel file under a column (Efforts).

Can anyone give me the macro for the above said problem..

Thanks in advance

Answer 1

It might make life a lot easier to keep everything in one workbook using separate sheets instead of completely separate files. Then you can make use of HLOOKUP, VLOOKUP, and referencing ranges with the Sheetname!Address format (Sheet1!A3:A4 for example)...

Answer 2

It should still be possible to have cells that reference cells from another workbook. I have done this with older versions of Excel. This link to the Microsoft site has instructions for 2003 version, but should still apply.