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

G

Guest

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)
 

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

indirect function 2
Set non-continuous PrintArea via Function / Name 0
Excel Excel spreadsheets opening at top instead of bottom. 4
INDIRECT doesn't retain data from external worksheets 2
Excel Spreadsheets keep moving 0
Referencing External files with slightly different names 4
Find Function behaving differently in different spreadsheets 1
Updating Indirect Reference(s) 3

Top