Autofill Sheet names?
 

Hello
My Excel 2003 workbook contains sheets labeled by month.

In A1...=Jan!$B$6
Is there anyway to autofill the sheet name so that A2 contains =Feb!$b$6 etc


--
Thank-you and all suggestions are appreciated.

Try this in A1:

=INDIRECT("'"&TEXT(--ROW()&"-1","mmm")&"'!B6")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello
My Excel 2003 workbook contains sheets labeled by month.

In A1...=Jan!$B$6
Is there anyway to autofill the sheet name so that A2
contains =Feb!$b$6 etc


--
Thank-you and all suggestions are appreciated.
.

Anauna

Place the sheet names Jan through Dec in a column(say M1:M12)

In A1 enter =INDIRECT(M1 & "!$B$6")

Drag/copy down.

If you wanted the sheet names in a column on a separate sheet the formula
would be

=INDIRECT(newsheet!M1 & "!$B$6")


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 11:39:02 -0800, Anauna
wrote:

Hello
My Excel 2003 workbook contains sheets labeled by month.

In A1...=Jan!$B$6
Is there anyway to autofill the sheet name so that A2 contains =Feb!$b$6 etc