Merge Excel files

[kajal]

Hi
I hope someone can help me with this.
I am trying to merge certain columns from different spreadsheets in excel into one spreadsheet.Which is the most efficient way of doing this.I'm sure there is a better method than copy pasting each time.

All suggestions are welcome
Thanks
kajal

 

[mvdmeij]

By using references to the other worksheet:
use references in the workbook where you want to merge data:

=[Name.xls]Sheetname!CellAdress (e.g. =[test.xls]test!A1

Mark.