Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hi, my title probably explains it all. I'm having trouble getting the indirect function to fetch data from another Excel file when the path is given in another cell. Basically I have column in my spreadsheet that computes the path and desired cell of another Excel file of which to grab the data from. So say column B has a whole bunch of cells that have *values* like: '\\server\folder1\[example.xls]sheet1'!C7 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Importing data into Excel | Excel Discussion (Misc queries) | |||
How do I automate upload of data from one excel file to another? | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |