Copying Specific Cells in a Column

[Royy]

Hi!

I need to copy some specific cells that contains the word "RPM" from Column A

Example

Great Person
Good Boy RPM
School Bus
College RPM
Amazing RPM
Sun Shine

I need to copy all those cells that contain RPM. There are thousand of entries so it is very difficult for me to pick them one by one.

Thanks in Advance

[arun88aries]

Hi Royy,

Try the enclosed file.

Regards,
Arun

[Royy]

Thanks a lot Arun. Your solution was perfect. It solved my problem in seconds.

Thumbs Up to you :-)