View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Andre7266 Andre7266 is offline
external usenet poster
 
Posts: 4
Default Copy specific data to second worksheet

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.