copy rows containing given values

[j.farr3ll]

I have a workbook with data in columns A:HN.

What I'm trying to do is copy any rows where the range O:HN contains a 3, 4, 5, 6 or 7 to a new sheet.

I have been using the following code:

Please Login or Register  to view this content.

and running it 5 times (with 3 as string, then 4, then 5 etc...)

However, I'm getting duplicates. I imagine where rows contain for example a 5 and 6? Is there a more accurate way to do this?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Or?

Please Login or Register  to view this content.

[j.farr3ll]

I have used the second code and it seems to work great. Many Thanks, James

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.