need Excel function like INDIRECT but can't open all spreadsheets

B

Big Al

Need to reference values in multiple spreadsheets using function like
INDIRECT, but I can not have all of the spreadsheets open a the same time.
 
B

Bob Phillips

INDIRECT only works with open spreadsheets. You could try Harlan Grove's
Pull function, which you can get at ftp://members.aol.com/hrlngrv/pull.zip

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top