Find and Select Specific Rows with text

Hi All,
Trying to get a sales report for specific item - "TRAY OF 38 POTTED PLANTS - 1 SPECIES" and the Qty. I'd like to select all rows with TRAY OF 38 POTTED PLANTS - 1 SPECIES and one cell below that. My goal is to move these into it's own Worksheet so I can create a Pivot Table to summarize our sales. My issue is that I can only mass-select cells with text "TRAY OF 38 POTTED PLANTS - 1 SPECIES" but I don't know how to select cells with TRAY OF 38 POTTED PLANTS - 1 SPECIES and the row below those cells.
The example attachment is a shortened report, actual report will have around 30,000 rows
Thanks in advance!

You're Amazing!!
Thank you soooo much BSB!

Glad I could help.

If the code runs slowly on your real data due to number of rows then you can try adding the lines in red in the version below to help speed it up a little.

Please Login or Register  to view this content.

BSB