View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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