Leave only rows containing

[juanp21]

Hi

I would like to know if this can be programmed

On Sheet 1 I would like to delete all rows that do not contain "RQ" on column H

Add a column left to Column A and number the lines with bottom borders to separate the car models


Any help or advise is greatly apreciated


Try12.xlsx

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[juanp21]

It works great . I changed column I for H

Can another piece of code be added to add the bottom borders and the numebers on column A like on the "Example" sheet

Thank you

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.