Ron de Bruin has some canned copy routines on his site that do work like
this:

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

should get you started.

--
Regards,
Tom Ogilvy


"steve" wrote in message
...
i have sheet 1 with all of the info imaginable. i want to create sheets
after that with certain pieces of that data.

Examplef
For Sheet 3, i want it to go through a column in sheet 1 and find every
time
it has the name keith. i then want it to copy those corrosponding rows
into
sheet 3.
I have already copied the format of sheet 1 into sheet three, so the
titles
are already there. what sort of code should i use for this?