XLDOESNOTWORK
New Member
- Joined
- Apr 28, 2002
- Messages
- 1
Can someone make this work? Is it possible?
I need to make a reference to the particular worksheet, but I want the name of the worksheet in the reference depend on the input in lets say A1. For example if I type "sheet 35" in A1, then all my references will be pointing to the sheet named "sheet 35". Anotherwords I am trying to make this work [=variableworksheetname!B1], where variableworksheetname is the name that I define in A1 of the current worksheet. SO all I would have to do is to put a new name/variable in A1, and it will automatically will get info from B1 of that name/variable/worksheet. The purpose of doing this is to make it easier to update all the reffering links to the other sheets without retyping the formulas in each of the references. I would be interested in any alternative ways of solving this problem. Just imagine that you have 1000 worksheets and you would like to extract specific information from the worksheet's name that you spacify in A1. Thanks a lot guys!!!!
I need to make a reference to the particular worksheet, but I want the name of the worksheet in the reference depend on the input in lets say A1. For example if I type "sheet 35" in A1, then all my references will be pointing to the sheet named "sheet 35". Anotherwords I am trying to make this work [=variableworksheetname!B1], where variableworksheetname is the name that I define in A1 of the current worksheet. SO all I would have to do is to put a new name/variable in A1, and it will automatically will get info from B1 of that name/variable/worksheet. The purpose of doing this is to make it easier to update all the reffering links to the other sheets without retyping the formulas in each of the references. I would be interested in any alternative ways of solving this problem. Just imagine that you have 1000 worksheets and you would like to extract specific information from the worksheet's name that you spacify in A1. Thanks a lot guys!!!!