Hi Everyone,
I'm new here.
I have a question about having a cell referencing in another workbook. I hope my explanation makes sense.
Let's say I have 3 worksheets called "Data1", "Data2" and "Report"
In 'Report'!A1 I have typed in the text "Data1" or "Data2".
In 'Report'!A2, I would like a formula to reference A1 in the worksheet named in the cell 'Report'!A1 .
eg.
1. 'Report!A1 says "Data1", so 'Report!A2 will reference 'Data1'!A1
2. 'Report!A1 says "Data2", so 'Report!A2 will reference 'Data2'!A1
Is this possible to do within a formula and no macros?
Thanks.
I'm new here.
I have a question about having a cell referencing in another workbook. I hope my explanation makes sense.
Let's say I have 3 worksheets called "Data1", "Data2" and "Report"
In 'Report'!A1 I have typed in the text "Data1" or "Data2".
In 'Report'!A2, I would like a formula to reference A1 in the worksheet named in the cell 'Report'!A1 .
eg.
1. 'Report!A1 says "Data1", so 'Report!A2 will reference 'Data1'!A1
2. 'Report!A1 says "Data2", so 'Report!A2 will reference 'Data2'!A1
Is this possible to do within a formula and no macros?
Thanks.