Tutorial :Copy a column of data from an Excel file to another file



Question:

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


Solution: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)...


Solution: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.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »