| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
INDIRECT.EXT question
I am trying to use INDIRECT.EXT function to get values from a different
worksheet. I am typing the path in a cell in the following format in cell A1: "'G:\Operations\Timesheets\2005\[2005_abcd.xls]YTD'!$N$6" and then using INDIRECT.EXT(A1) function but I am getting #REF instead of any values. Can anybody help resolve this or suggest a better option. I have to type the path there is no way around it. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Page Break View - not the usual question | Excel Discussion (Misc queries) | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| 2 part question on averaging | Excel Discussion (Misc queries) | |||
Threaded Mode
