C
claytorm
Hi,
I have a long series of sheets: Sheet1, Sheet2, Sheet3 etc. In each of
those sheets, i want to extract the sheet name and turn it into a
reference in A1 of that sheet. So, A1 of Sheet1 would refer to cell A1
in the Main sheet (=Main!A1), A1 of Sheet2 to refer to A2 in the Main
sheet (=Main!A2) etc. How can I do this?
Thanks,
Bertie.
I have a long series of sheets: Sheet1, Sheet2, Sheet3 etc. In each of
those sheets, i want to extract the sheet name and turn it into a
reference in A1 of that sheet. So, A1 of Sheet1 would refer to cell A1
in the Main sheet (=Main!A1), A1 of Sheet2 to refer to A2 in the Main
sheet (=Main!A2) etc. How can I do this?
Thanks,
Bertie.