Copy specific data to second worksheet

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

 

[Ron de Bruin]

Start here
http://www.rondebruin.nl/copy5.htm

 

[Per Jessen]

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

 

[Andre7266]

I read the notes that you refer to. Where do I tell it what value I want to
compare to?

 

[Ron de Bruin]

If you read the information
http://www.rondebruin.nl/copy5.htm#AutoFilter

You can set the sheet, filter range, field and filter value

Below the macro you can see how to do it manual

You can also use this add-in if you want it easy
http://www.rondebruin.nl/easyfilter.htm