mikeburg
06-15-2016, 08:37 AM
Using an Excel formula, I am trying to get a cell's data from another worksheet referring to the worksheet name from another cell.
For example,
Worksheet 1 B5 = 24 (the sheet tabs name)
Worksheet 1 W6 is my formula that does not work
="B5"!$A$4
Sheet 2 whose tab name is 24 $A$4 has the data, 115 in this case, I want to return to cell W6.
Apparently I can't get the syntax correct. I am using XP version of Excel. Thanks so very much! mikeburg
For example,
Worksheet 1 B5 = 24 (the sheet tabs name)
Worksheet 1 W6 is my formula that does not work
="B5"!$A$4
Sheet 2 whose tab name is 24 $A$4 has the data, 115 in this case, I want to return to cell W6.
Apparently I can't get the syntax correct. I am using XP version of Excel. Thanks so very much! mikeburg