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