Extract sheet name/number to cell

[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.

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

"claytorm" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> claytorm
> ------------------------------------------------------------------------
> claytorm's Profile:
http://www.excelforum.com/member.php...o&userid=11610
> View this thread: http://www.excelforum.com/showthread...hreadid=382416
>