Variable Filename calls
Ok, Here's another thing I'm having trouble getting to work. I would
like to concatenate a file and cell name to use to retrieve a value. I
have a master sheet that contains a filename value in a cell. I would
then use the filename value contained in that cell to call a value from
another sheet. Here is an example of what I mean:
File_Names.xls!FILE_SALES_JUNE_2006
['FILE_SALES_JUNE_2006' is concatenated, cell contains value...]
----
Sales_June_2006.xls
----
I would then use that value to call a concatenated cell value from
another sheet
Sales_June_2006.xls!S_1001_1
['S_1001_1' is concatenated, cell contains value...]
----
8804 <----- value needed
----
I concatenate the needed filename correctly, I just can't seem to get
resulting values to be used in the file/cellname call. How would you
get a "File_Names.xls!FILE_SALES_JUNE_2006" command to accept a variable
as a cellname and a "Sales_June_2006.xls!S_1001_1" to accept cell value
and variable name as both the filename and the cell name in the call.
Thanks in advance for any help.
-Daniel Canham
|