Form an array based on criteria and paste to new worksheet

[BadLilBrat]

I have a table with 5 columns and the 3rd column is blank (if that matters)

the 5th column has a value of eith A or B.

I want to find all the rows where the 5th column is B and paste the ENTIRE ROW tino a new worksheet and continue doing this until all the rows where the 5th column is B is in that new worksheet.

Could someone please help?

[Carim]

Hi,

Have you tried Data Advanced Filter ...?

[MDubbelboer]

something quick

you should be able to modify it to suit your needs

Please Login or Register  to view this content.