calling a value from another file using a variable in the file
I have no idea what you mean by this response....
"T. Valko" wrote:
See your other post
--
Biff
Microsoft Excel MVP
"DA_Potts" wrote in message
...
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents
a
date of the month, 1-31.
=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))
In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.
Any ideas?
|