Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested String Filename Variable | Excel Worksheet Functions | |||
Put Filename Variable in Macro | Excel Discussion (Misc queries) | |||
Put Filename Variable in Macro | Excel Programming | |||
Filename Variable? | Excel Programming | |||
counting cells and using a variable filename?!?! | Excel Programming |