MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Automate filling-in months column

Posted by Chris Webb on February 11, 2002 5:54 AM

If the user types "Jan" in A1, I would like the rest of tne months to fill in automatically down to "Dec" in A12. If the user types in another month, say "Mar" in A1 it should autofill down to "Feb" in A12.
I've tried =EDATE and autocomplete without success. Any help appreciated.

Posted by DK on February 11, 2002 6:15 AM

Not sure if you can do it by just typing in Jan but it works for me if you type Jan02 in A1 and then have =EDATE(A1,1) in A2, =EDATE(A1,1) in A3 and so on.

The alternative is to use VBA.


Posted by Mark W. on February 11, 2002 6:46 AM

Select cell A1 and drag the fill handle (the
black square in the lower right-hand corner)
of cell A1.

Posted by Chris W on February 11, 2002 9:28 AM

Posted by Chris W on February 11, 2002 9:29 AM

Thanks to both for your help