complex macro

here goes.....

i want to record/ create macro that inserts 12 new lines in a sheet with the months of the year going down in column 'L' . every time the macro runs, it needs to be able to find the next blank line, so it doesnt over write any data (which is the problem iv been having)

also as the macro is run i need some equations to be exectued in relation to the pre defined jan, feb, march, april, etc.

the code is:

"=SUMPRODUCT((MONTH($E$6:$E$20)=ROW(A1))*($H$6:$H$20 <>""))"

also other simple 'sum' functions need to be executed upon the macro being run.

can this be done.

please advise

thanks

i would like every time the macro is run to insert 12 new lines in the next blank row

view 'test.xls'

i would like the macro to enter 12 new lines with the months of the year to be displayed. so when you clcik th button, the assigned macro will insert 12 new lines in cell G27 onwards. once this has been done, if i click the button again, 12 new lines will be inserted, but below the prviously inserted lines.

i dont know if im making sense or not. i hop the attached sort of explains what im tryin to do. thanks.