complex macro

[sukhi_01]

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

[mrice]

Its not totally clear where you want to put your formula - an attachment would help.

Getting the months can be performed with this macro.

Please Login or Register  to view this content.

giving the name of the month in the language of the regional setting.

[mudraker]

Thread closed for invalid title & Duplicate thread posting