Either sort and copy all at once or
Have a look in vba help index for FIND and FINDNEXT. There is a good
example.

--
Don Guillett
SalesAid Software

"JI" wrote in message
oups.com...
Im looking for a code sample that will look at a list in excel and pull
out entire rows based on referenced cell critera and paste those rows
into seperate sheet within the workbook. Anyone have something like
this that they have done before? Any help/direction is greatly
appreciated.