Insert Row with month of date change

Hi,
How can I insert Row with the "month" change in column "C"???
Please help,
Thanks in advance for any help.
Cindy

Here is my excel:
DESIGN 4 3/2/2006 Bob
DESIGN 4 3/7/2006 Bob
SPL 9 5/3/2006 Clark
SPL 5 5/3/2006 Clark
SPL 4 5/3/2006 Clark
SPL 4 5/3/2006 Clark
340165 2 5/3/2006 Clark
Drawing 2 5/16/2006 Dave
Drawing 8 6/2/2006 Dave
340290 4 6/9/2006 Bob

Cindy

If the data as show is in the range A1:D10 then try

Please Login or Register  to view this content.

HTH

rylo

That work very good- Thank you very much!
Regards,
Cindy