Have a look at Ron deBruin's site.

http://www.rondebruin.nl/copy1.htm

Lots of code there which should give you some ideas.


Gord Dibben MS Excel MVP

On Sun, 27 Aug 2006 16:44:01 -0700, Rob wrote:

I am trying to find a macro/sub that will search for a cell that meets a
condition then select that entire row a copy it into another worksheet. Then
it needs to continue the search for more and do the same until the end of the
originating worksheet.

Any Ideas or offers?

Thanks in Advance.
Rob