Relative input for formula

T

Tom

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet Formatting 0
Conditionally Formatting 1
Conditional Formatting 0
Excel 2002: changing link formula from absolute to relative 3
Another MATCH and INDEX problem 1
Build link to an other excell doc 1
Build a link to an other excell document. 1
Missing default cell styles on some large existing spreadsheets 0

Top