Try this example
http://www.rondebruin.nl/copy5.htm

Post back if you need more help


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mr B" wrote in message ...
I have a sheet setup that is a list of people who have signed things out from our office. It includes date/timestamp information,
user IDs, and items borrowed.

I want a way to put someone's ID in a box and have it then do a search and if it finds that ID in the list, it would Copy the
whole row (just to make it easier) onto a new Sheet. This I can do.

However, I then want it to continue through the sheet looking for more instances of the text and to continue to copy the data for
all rows where it finds the person's ID. Basically to pull a history for the user and see what they have checked out and when.

How would I do the command (or loop) to repeat the search until it hits the end of the data?

Can I somehow put a set VAR = cells.find... inside of a loop and say Search, copy data, search again, until it doesn't find it?

Any guidance would be great.