Need Some Advice on Getting Data From One file to another

**mooredb** · 11-30-2012, 06:49 PM

I have a user that needs to use their own excel file to keep track of their budget because of the extra data that is need to support it. However, we have a master file that we need to get a few cells copied over to be able to create and run pivot tables off all the data. What is the best way to get their data into the master file? I will need to be able to have the master file to be able to add rows and new data is entered in the other file, is that possible too?

Thanks for any advice.

**Richard Buttrey** · 11-30-2012, 06:57 PM

Hi,

Assuming the two files are on the same network the easiest way is to simply link the cells directly. Open both workbooks in memory and create the links in the master file by entering =, then navigate to the supporting file click the cell that contains the cell you want and Enter.

Regards