Copy specific data to second worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre7266 - 13 May 2008 19:29 GMT

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.

Reply to this Message

Ron de Bruin - 13 May 2008 20:03 GMT

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

Signature

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

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

Reply to this Message

Andre7266 - 13 May 2008 20:24 GMT

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

> Start here
> http://www.rondebruin.nl/copy5.htm
[quoted text clipped - 4 lines]
> > second worksheet? If I could do this automatically, this second sheet would
> > grow along with the source.

Reply to this Message

Ron de Bruin - 13 May 2008 20:39 GMT

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

Signature

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

>I read the notes that you refer to. Where do I tell it what value I want to
> compare to?
[quoted text clipped - 7 lines]
>> > second worksheet? If I could do this automatically, this second sheet would
>> > grow along with the source.

Reply to this Message

Per Jessen - 13 May 2008 20:12 GMT

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

Reply to this Message