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

--

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


"Andre7266" wrote in message ...
I read the notes that you refer to. Where do I tell it what value I want to
compare to?

"Ron de Bruin" wrote:

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.