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