Does anyone have any suggestions on how to do it in excel?
In cell A1, there is a text "0001",
In cell B1, there is a filing structure
='E:\directory\0001\[file.xls]sheet1'!M14
I would like to insert any 4-digit code into filing structure for receiving
value.
If I type in "0005" in cell A1, then the directory will return in cell B1.
='E:\directory\0005\[file.xls]sheet1'!M14
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric