| 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 |
| 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 | |||
Threaded Mode
