I turn that setting off. I find that I don't understand the rules that it
uses. I always copy and paste.

If you want a macro that may do what you want, visit David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Stan wrote:

Thanks Dave for your help.
I checked the tab and it was checked.. What I saw happen now when I put
a new date in it added the formulas for month and year... I added the
info in the following 3 columns, but it did not add the formulas for
the next adjacent column...

--

Dave Peterson