If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 = 'Qata\[File001.xls]Sheet1'!H1/100 Then switch to File002 Thank you, regards |
#2
|
|||
|
|||
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 = 'Qata\[File001.xls]Sheet1'!H1/100 Then switch to File002 Thank you, regards |
Thread Tools | |
Display Modes | |
|
|