VBA/Macro to copy a set of rows based on a cell criteria and paste it in new location

Hi Experts,

Need your expertise help in solving this. Bit badly needed.

I would like to copy the contents of rows (O,P,Q,R) based on cell criteria N and Paste it in the next available blank rows of (A,B,C and D)
Please help me in solving this.

VBA/Macro to copy a set of rows(O,P,Q,R) based on Cell criteria N and Paste it in next available rows (A,B,C,D)

Attached is the excel file for your reference. As you can see Column N has texts "New". Whenver the column N finds "New" the contents of Column O,P,Q and R to be copied to next blank area in Column A,B,C and D.

Need your help as i am a novice in VB/Macro

Thanks in Advance.
Nids

Hi Richard,

Works perfectly. Thankyou. There is a small hitch though. Is it possible to paste only once.
Right now as and when i run more than once, the duplicates are created in column A. I would like to avoid duplicates.

Need your hlep in avoiding creating duplicates eventhough when the macro is run multiple times.

Thanks in Advance.

Regards,
Nids