Linking multiple worksheets
 

I have 100 workbooks that I want to link to a single new workbook, linking 10
consistent cell locations each of data. The workbooks I want to link to are
in 10 different directories. I have in Column A the directory path locations
(C:\My Files\test1\10differentfolders\) and in Column B the file names
(100filenames.xls) in 100 rows and I would like to make the link in columns C
through L. I want to be able to pull the formula down and accross to get the
correct formulas to link my cells. This will save lots of time. Any
suggesgtions???

Any suggesgtions???

Yes, get a database.

L


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476355