View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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?