Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Relative input for formula
Lost the touch,
Thanks in advance for ANY help or direction. I have looked thru group, but can't find this answer. Excell 2003, 512ram 30gigs free I have about 90 spreadsheets that are exactly alike. Creating a new spreadsheet that will 'link' data from selected spreadsheets. My link formula is ='C:\budget\[AE1.XLS]aE1'!B7. My requirement/question is that I want to replace [AE1.xls] with a reference to cell A1 so that if I type AE2 in cell A1 that the formula will look like ='C:\budget\[AE2.XLS]aE2'!B7. Again I do appreciate your help. |
#2
|
|||
|
|||
Relative input for formula
That would normally addressed with INDIRECT, but that only works with open
workbooks. If you want to use closed workbooks, I assume that you do, then download and install Longre's free morefunc.xll add-in from http://xcell05.free.fr/ -- HTH RP (remove nothere from the email address if mailing direct) "Tom" wrote in message ups.com... Lost the touch, Thanks in advance for ANY help or direction. I have looked thru group, but can't find this answer. Excell 2003, 512ram 30gigs free I have about 90 spreadsheets that are exactly alike. Creating a new spreadsheet that will 'link' data from selected spreadsheets. My link formula is ='C:\budget\[AE1.XLS]aE1'!B7. My requirement/question is that I want to replace [AE1.xls] with a reference to cell A1 so that if I type AE2 in cell A1 that the formula will look like ='C:\budget\[AE2.XLS]aE2'!B7. Again I do appreciate your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
***Two Input Data Tables*** | Excel Discussion (Misc queries) | |||
input box | Excel Discussion (Misc queries) | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) |