| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
indirect reference
I want to have two cells where one tells me the name of a file, and the other
tells me the name of a sheet tab in that file. I would like to be able to use those two values in a cell to complete a reference to a cell (let's say B2 of that file's tab). What is the formatting for this? Thx. -- Boris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| dependent combo box list, with indirect reference | Excel Discussion (Misc queries) | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Threaded Mode
