Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Indirect Function
When using the Indirect function, how do I look for a tab or sheet that is in
a different Excell file. In this case, INDIRECT(A4&"!b5") if in AR4, summary is typed then the formula will look for the value that is in b5 from the summary Tab or sheet. but what if I am interested in a Tab that is in a different file? Pester |
#2
|
|||
|
|||
The bad news is =indirect() won't work with closed files.
Will that other workbook be open? If no, then maybe you could use a userdefined function created by Harlan Grove: http://www.google.com/groups?selm=sH...wsranger. com If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Pester wrote: When using the Indirect function, how do I look for a tab or sheet that is in a different Excell file. In this case, INDIRECT(A4&"!b5") if in AR4, summary is typed then the formula will look for the value that is in b5 from the summary Tab or sheet. but what if I am interested in a Tab that is in a different file? Pester -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect Function Doesn't like non-contiguous ranges | Excel Discussion (Misc queries) | |||
indirect worksheet function in excel | Excel Worksheet Functions | |||
INDIRECT function error | Excel Discussion (Misc queries) | |||
INDIRECT function question | Excel Worksheet Functions | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions |