Autofill Sheet names?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this in A1:

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

HTH
Jason
Atlanta, GA
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill Worksheets / Worksheet Names 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Autofill column values in formulas 4
Need to merge worksheets - Excel 2003 0
Macro for Calendar 1
A formula that autofills by trend, not linear 3
AutoFill Linked Cells 8
Autofill but with a custom rule?? 1

Back
Top