| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
need Excel function like INDIRECT but can't open all spreadsheets
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. |
|
#2
|
|||
|
|||
|
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) "Big Al" <Big wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel files in separate program windows | Excel Discussion (Misc queries) | |||
| indirect worksheet function in excel | Excel Worksheet Functions | |||
| Cannot open Excel attachment from e-mail when Excel is already ope | Excel Discussion (Misc queries) | |||
| When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
| Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
Hybrid Mode
