working with two sheets

[Guest]

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?

 

[Ron de Bruin]

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

 

[Tom Ogilvy]

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.

 

[Guest]

thanks guys

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