reference work sheet name by using a formula
 

I have multiple sheets. Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet name
using a label.

I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1
cell "A2".

Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5.

Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would
refer to that cell "A1". example =A1!F5

reference work sheet name by using a formula
 

=INDIRECT(A1&"!F5")


"worksheet reference by label" wrote:

I have multiple sheets. Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet name
using a label.

I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1
cell "A2".

Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5.

Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would
refer to that cell "A1". example =A1!F5

reference work sheet name by using a formula
 

If A1 contains XYZ you can use in A2:

=INDIRECT(A1&"!F5) to get the value from XYZ!F5

Tyro

"worksheet reference by label" <worksheet reference by
wrote in message
...
I have multiple sheets. Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet
name
using a label.

I want to copy a value from sheet named "XYZ" cell "F5" to my current
Sheet1
cell "A2".

Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5.

Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula
would
refer to that cell "A1". example =A1!F5

reference work sheet name by using a formula
 

Correction:

=INDIRECT(A1&"!F5") to get the value from XYZ!F5

"Tyro" wrote in message
.. .
If A1 contains XYZ you can use in A2:

=INDIRECT(A1&"!F5) to get the value from XYZ!F5

Tyro

"worksheet reference by label" <worksheet reference by
wrote in message
...
I have multiple sheets. Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet
name
using a label.

I want to copy a value from sheet named "XYZ" cell "F5" to my current
Sheet1
cell "A2".

Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5.

Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula
would
refer to that cell "A1". example =A1!F5