Excel 2007 : need to copy the found row and the next 20 rows

[grsnipe]

I have a code for searching a data only report. The problem is how do I get it to copy the found row and the next 20 rows. Please see sample data report attached and the search code I am using below. The code below would find row 7 in the sample data report, I need to copy row 7 thru row 27. The copied rows would paste to another sheet "Invoiced Sort". Thanks to all that look and try to help.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Please review the correct format for the code tags. I see you'd attempted to add tags but they were wrapped inside a Quote and didn't have the close \CODE syntax.

How about something like

Please Login or Register  to view this content.

try and avoid selecting (and activating) cells and sheets. It's rarely needed and just slows code down as well as being longer.

HTH

[grsnipe]

Thanks for the help, it is greatly appreciated.