Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ralph
 
Posts: n/a
Default 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???
  #2   Report Post  
Lilliabeth
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking between multiple worksheets, workbooks and columns cmvbfore Excel Discussion (Misc queries) 0 October 4th 05 06:58 PM
Functions across multiple worksheets starlight Excel Worksheet Functions 0 August 10th 05 05:10 PM
Linking and formatting multiple worksheets kellyc Excel Worksheet Functions 2 July 14th 05 04:26 PM
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Countif with multiple criteria and multiple worksheets JJ Excel Worksheet Functions 1 December 28th 04 07:37 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"