Macro to Copy Entire Rows if Column Equals

Hi,
Sorry to be back again asking for help (I hope you guys don't get tired of me).
I thought this one is a bit complicated.
The dummy spreadsheet (See attached), contains data from Column V to Column AM.
I would like to copy the entire row if the value on Column AI is equal to "ABC".
The Rows needs to be copied on Column A to Column R.
This is just a part of the Macro that I am trying to build but got stucked with this part.
Appreciate any help. Thank you in advance.

Regards,
Andrew

Andrew,

We will never get tired of you .

Try this code

Please Login or Register  to view this content.

Put it in a standard module.

So should a row be copied only if both conditions are met? In that case change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

else if any 1 condition should be met for a single row then change it to

Please Login or Register  to view this content.