Hi All!

I a complete newbie to this vba programming and through my research of topics it appears that each thread is tailored specifically to the request, which is great. However, I am trying to take bits and pieces from each and having trouble compiling my own code. I am trying to insert three rows below the last data line in column A and copy and paste the previous formulas to the inserted rows. In addition, the data in column A consists of dates and I would like to program the Macro to auto-fill these dates.

As an example:

A B C D
1 01/30/12 Formula A Formula B Formula C
2 02/29/12 Formula A Formula B Formula C
3 03/31/12 Formula A Formula B Formula C
4 04/30/12 Formula A Formula B Formula C
5 05/31/12 Formula A Formula B Formula C
6 06/30/12 Formula A Formula B Formula C

Therefore the end would result would be the data above and:

A B C D
7 07/31/12 Formula A Formula B Formula C
8 08/31/12 Formula A Formula B Formula C
9 09/30/12 Formula A Formula B Formula C

And then so on, everytime i run the macro

10 10/31/12 Formula A Formula B Formula C
11 11/30/12 Formula A Formula B Formula C
12 12/31/12 Formula A Formula B Formula C


I apologize in advance if this is a very elementary request and appreciate any insight that can be given.

Thanks,
Jlee