W
Warren
Can someone help with a worksheet reference question?
How do I refer to another sheet in the same workbook in a formula?
For example:
I have, say 40 sheets, in a workbook. The sheets are named Summary, AAA,
BBB, CCC..... in the workbook.
On the Summary sheet
Column D contains the names of all the sheets in the workbook.
For example:
D1 has 'AAA'
D2 has 'BBB'
D3 has 'CCC'
In the cells in column E of the Summary sheet, I like to have the value of
Cell A3 from the sheet which has its name in column D.
For example,
Since D1 is AAA, then E1 should refer to the value of Cell A3 of sheet AAA
E2 should refer to the value of sheet BBB, Cell A3
E3 should refer to the value of sheet CCC, Cell A3
and so on.
It is easy if I only have few sheets in the workbook. I can just manually
type in the formula =AAA!$A$3. However, if I have 50 sheets in the
workbook, I would like to have a generic formula that checks the value of
cells in column D and use it in cells in column E.
Can anyone help?
Thanks
wachen
How do I refer to another sheet in the same workbook in a formula?
For example:
I have, say 40 sheets, in a workbook. The sheets are named Summary, AAA,
BBB, CCC..... in the workbook.
On the Summary sheet
Column D contains the names of all the sheets in the workbook.
For example:
D1 has 'AAA'
D2 has 'BBB'
D3 has 'CCC'
In the cells in column E of the Summary sheet, I like to have the value of
Cell A3 from the sheet which has its name in column D.
For example,
Since D1 is AAA, then E1 should refer to the value of Cell A3 of sheet AAA
E2 should refer to the value of sheet BBB, Cell A3
E3 should refer to the value of sheet CCC, Cell A3
and so on.
It is easy if I only have few sheets in the workbook. I can just manually
type in the formula =AAA!$A$3. However, if I have 50 sheets in the
workbook, I would like to have a generic formula that checks the value of
cells in column D and use it in cells in column E.
Can anyone help?
Thanks
wachen