This would save me a ton of time -- please help.
I have a spreadsheet with several worksheets. The name of each work sheet is in a cell in the primary worksheet. For example
A1 has the text value "sheet1" (with no quotes). B1 has the value "sheet2" and so on.
In cell A2 I need to reference a field in sheet1. In B2 I need to reference a field in sheet2 and so on.
So, in cells A2, B2, C2, .... etc, I would like to write a formula that references the correct sheet without hardcoding it. For example, in A2 I would like the equivalent of sheet1!A1 but without having to type out "sheet1", rather look at the name of the worksheet in A1.
I have tried a ton of things but the only thing that I get is actually Sheet1!A1 showing up in the cell.
Any suggestions?
I have a spreadsheet with several worksheets. The name of each work sheet is in a cell in the primary worksheet. For example
A1 has the text value "sheet1" (with no quotes). B1 has the value "sheet2" and so on.
In cell A2 I need to reference a field in sheet1. In B2 I need to reference a field in sheet2 and so on.
So, in cells A2, B2, C2, .... etc, I would like to write a formula that references the correct sheet without hardcoding it. For example, in A2 I would like the equivalent of sheet1!A1 but without having to type out "sheet1", rather look at the name of the worksheet in A1.
I have tried a ton of things but the only thing that I get is actually Sheet1!A1 showing up in the cell.
Any suggestions?