Hello All,
I've got a workbook with c.100 worksheets in it.
I have created another "index" worksheet, which automatically lists each worksheet's name in an individual row in column B. i.e.
in B3 901
in B4 902
in B5 907
in B6 910
and so on.
I want to display a value from each worksheet in column C of the "index" worksheet.
If it was only 1 or 2 worksheets, I could just type the following formulae into each of the column C cells:
=901!F23
=902!F23
I don't want to have to do that for c.100 cells though.
Simply, I tried (in cell C2), typing =(B4)!F23), in the vain hope that would work.
Needless to say, it didn't.
Also tried =$B$4!F23 , and ="B4"!F23 ; again, neither of which worked.
I'm beyond my limit with cross-referencing worksheets, and then some, so any help would be greatly appreciated.
I've got a workbook with c.100 worksheets in it.
I have created another "index" worksheet, which automatically lists each worksheet's name in an individual row in column B. i.e.
in B3 901
in B4 902
in B5 907
in B6 910
and so on.
I want to display a value from each worksheet in column C of the "index" worksheet.
If it was only 1 or 2 worksheets, I could just type the following formulae into each of the column C cells:
=901!F23
=902!F23
I don't want to have to do that for c.100 cells though.
Simply, I tried (in cell C2), typing =(B4)!F23), in the vain hope that would work.
Needless to say, it didn't.
Also tried =$B$4!F23 , and ="B4"!F23 ; again, neither of which worked.
I'm beyond my limit with cross-referencing worksheets, and then some, so any help would be greatly appreciated.