Copy specific data to second worksheet

  • Thread starter Thread starter Andre7266
  • Start date Start date
A

Andre7266

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.
 
Hi

Select all your records, then goto Data > Filter > Autofilter > Click on the
filter in the status column and select Void.

Copy the filtered data to the desired sheet.

Regards,
Per
 
I read the notes that you refer to. Where do I tell it what value I want to
compare to?
 
Back
Top