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.

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.

Copy specific data to second worksheet
 

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" skrev i meddelelsen
...
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.

Copy specific data to second worksheet
 

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.

Copy specific data to second worksheet
 

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.