| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy specific records from a worksheet to another | Excel Worksheet Functions | |||
| Copy data to another wb based on specific criteria | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| How do I copy specific items to another worksheet? | Excel Worksheet Functions | |||
| copy/print specific data | Excel Worksheet Functions | |||
Linear Mode
