D
Duane
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.
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.