Is there away to create a sheet reference inside a formula. For example I want to make cell C2 in sheet 1 = to cell C2 in sheet 2.
Can I make a formula that refers to the sheet name in cell B2 in sheet 1.
A B C D E
1
2 sheet 2 ='sheet 2'(C2)
3 sheet 3 ='sheet 3'(C2)
4 sheet 4 ='sheet 4'(C2)
so the formula in C2 I would like to make refer to the name in B2, if that makes any sense!
Cheers
Can I make a formula that refers to the sheet name in cell B2 in sheet 1.
A B C D E
1
2 sheet 2 ='sheet 2'(C2)
3 sheet 3 ='sheet 3'(C2)
4 sheet 4 ='sheet 4'(C2)
so the formula in C2 I would like to make refer to the name in B2, if that makes any sense!
Cheers