Thread: Copy specific data to second worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Copy specific data to second worksheet
Start here
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Andre7266" wrote in message ...
I have a worksheet with about 2,000 records. I have a status field with 3
possible values - Open, Closed or Void. I have about 25 records in this
worksheet with a status of void. How could I copy ONLY those records to a
second worksheet? If I could do this automatically, this second sheet would
grow along with the source.
Reply With QuoteReply With Quote