Macro to link two files- please help!
 

I have a base file for summarizing some data, the problem is that the
data comes from a different excel spreadsheet. What I want to do is
make a function that pulls the data from another spreadsheet into my
base file. It would be easy if it were just one excel sheet, but this
job would require where the data is pulled from a data file which has
many modified versions.

Can anyone tell me how to do this? The files with the data will be
structured the same but with different data entered in. I just want a
button so I can click the file I want the data from and have it show up
on my summarizing base file. Hopefully this isn't confusing...

Thanks!


--
kai_charmer_ge
------------------------------------------------------------------------
kai_charmer_ge's Profile: http://www.excelforum.com/member.php...o&userid=35717
View this thread: http://www.excelforum.com/showthread...hreadid=554987