Hi Troy

See
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Troy" wrote in message ...
I'm using excel 2003.

I have a worksheet full of maintenance data. Each row on this sheet has a
machine number, date, repair information, etc.

I'm trying to make a marco to search thur the list for a specific machine
number copy all the data from that row and paste it on a different sheet.
All of the entries for that machine number would then be copied to that new
sheet.


Does anyone know how to do this?