Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File name and Sheet name a variable.
I know this has been asked, and I have tried to figure out the ansewers but
without success. I will ask how I am trying to do it. the first part is as follows: A cell contains the name of a work sheet in a different workbook. If the cell value changes, I would like the new name to look to that worksheet in the different workbook. ={MH06S0Aug08dy.xls]Sheet1!H$13 "Sheet1" is the variable and would like it to refer to a cell value. I would like it to work if the workbook it refers to is closed as well. Part two is being able to have the file name a variable as well, but this part is not nearly as time saving as the first part of the question would be. Thanks for all the help in this forum. It is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
calling a value from another file using a variable in the file nam | Excel Worksheet Functions | |||
calling a value from another file using a variable in the file nam | Excel Discussion (Misc queries) | |||
Variable sheet and Formula Sheet | Excel Discussion (Misc queries) | |||
variable in a link where the variable is the name of the sheet | Excel Worksheet Functions |