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
|