ExcelBanter - working with two sheets

thanks guys

"Ron de Bruin" wrote:

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

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

"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?