Selecting the newly added row and filling that row with predefined data

HI,

I have an excel sheet where one of my column contains Value 1 as a unique value. I have managed to make a macro to add a row above whenever 1 value comes. Now i have to add a predefined data in that newly added row. Can this be done by the macro .

I am attaching a sample excel which contains the macro to add row.

Kindly help , thanks in advance.

Regards,
Mayur Sample.xlsm

try it

Please Login or Register  to view this content.

Hi,

Thanks Nilem , That worked beautifully , One more help i want if possible it will be great . Like Captain added in C column i also want to add "2012" in column D , and " Mumbai" in E column.

Can u extend this code such that this will possible .

Thanks ,
Mayur

just change this line

Please Login or Register  to view this content.