Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
variable path
I'm trying to vary the source of some information, How can I use a drop down
list for example to select a new source for info in a cell? example: Q:\Data\File001.xls Q:\Data\File002.xls Formula in A1 Cell = 'Q:Data\[File001.xls]Sheet1'!H1/100 Then switch to File002 Thank you, regards |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
variable path
Hi Gerardo,
Check out the INDIRECT function. Do note, though, that this function will return error values if the source workbooks are not open. The alternative is to use a macro to replace the filenames in specified cells. -- Cheers macropod [Microsoft MVP - Word] "Gerardo" wrote in message ... I'm trying to vary the source of some information, How can I use a drop down list for example to select a new source for info in a cell? example: Q:\Data\File001.xls Q:\Data\File002.xls Formula in A1 Cell = 'Q:Data\[File001.xls]Sheet1'!H1/100 Then switch to File002 Thank you, regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Vlookup using variable path name for range value | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions |