Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference Worksheet Name
OK, I was able to use the indirect function to help. I'm half of the way to
where I want to be. In A1, I hard coded Sheet1 for the worksheet name. Then, in B1, I use =INDIRECT(A1&"!b10") to get a value from Sheet1. However, I'd like to be able to change the tab name from Sheet1 to PlantTest and have the text value in A1 change to PlantTest automatically. Is there a way to do this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet reference | Excel Discussion (Misc queries) | |||
Using cell contents to reference worksheet names | Excel Discussion (Misc queries) | |||
Worksheet reference behaving funny | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference a cell to get worksheet name | Excel Worksheet Functions |