Changing Document Names within Formulas

Closed
gman - Jun 8, 2010 at 11:39 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 8, 2010 at 02:07 PM
I have what I will call a "main" Excel spreadsheet that I want to pull information from other spreadsheets. I want each line on the main sheet to pull information from different spreadsheets that will be named numerically, i.e. 1001.exl, 1002.exl, etc. I have the first line on the main sheet pulling data from 1001.exl with specific cell references and that works great.

Now for the next line on the main sheet, I want to reference document 1002.exl but with the same cell references as before....just a different document. Of course if I edit and fill down, I get the 1001.exl document reference. How can I get the correct document references yet keep my cell references without having to do this manually.....it's a very long spreadsheet!



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 8, 2010 at 02:07 PM
post your formula
0