R
ronnielim
I am trying to get the contents of a cell to update the links of a
referenced file.
Let's say I am referencing the following file and cell:
='C:\[*Jan2004*-Expenses.xls]Sheet1'!$A$3
and I have a cell A1 which contains:
JAN2004
How do I get cell A1 to change the referenced filename?
Example:
I key in *Feb2004* in cell A1, and the referenced formula changes to:
='C:\[*Feb2004*-Expenses.xls]Sheet1'!$A$3
Thanks!
referenced file.
Let's say I am referencing the following file and cell:
='C:\[*Jan2004*-Expenses.xls]Sheet1'!$A$3
and I have a cell A1 which contains:
JAN2004
How do I get cell A1 to change the referenced filename?
Example:
I key in *Feb2004* in cell A1, and the referenced formula changes to:
='C:\[*Feb2004*-Expenses.xls]Sheet1'!$A$3
Thanks!