| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy specific records from a worksheet to another
Hi!
I am working on a worksheet containing employees records, a field contains the record "On Job" or "Resigned". I want to copy all the employees record who "Resigned" from the company to another worksheet in the same workbook. Thanx. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy specific records from a worksheet to another
Data Filter AutoFilter should filter the results you want.........then
just copy and paste to the new sheet.......... Vaya con Dios, Chuck, CABGx3 "Irfan" wrote: Hi! I am working on a worksheet containing employees records, a field contains the record "On Job" or "Resigned". I want to copy all the employees record who "Resigned" from the company to another worksheet in the same workbook. Thanx. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy specific records from a worksheet to another
Thanks. However, is their any way to do it automatically using vb script.
"CLR" wrote: Data Filter AutoFilter should filter the results you want.........then just copy and paste to the new sheet.......... Vaya con Dios, Chuck, CABGx3 "Irfan" wrote: Hi! I am working on a worksheet containing employees records, a field contains the record "On Job" or "Resigned". I want to copy all the employees record who "Resigned" from the company to another worksheet in the same workbook. Thanx. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy specific records from a worksheet to another
Yes, you can do it automatically using VBA
See Ron de Bruin's site for example code for copying filtered results to another sheet. http://www.rondebruin.nl/copy5.htm Gord Dibben MS Excel MVP On Tue, 29 Jan 2008 02:56:00 -0800, Irfan wrote: Thanks. However, is their any way to do it automatically using vb script. "CLR" wrote: Data Filter AutoFilter should filter the results you want.........then just copy and paste to the new sheet.......... Vaya con Dios, Chuck, CABGx3 "Irfan" wrote: Hi! I am working on a worksheet containing employees records, a field contains the record "On Job" or "Resigned". I want to copy all the employees record who "Resigned" from the company to another worksheet in the same workbook. Thanx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy records with specific text from one wkbk to another | Excel Worksheet Functions | |||
| Copy all records matching "Text" criteria to new worksheet | Excel Worksheet Functions | |||
| How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
| How do I copy specific items to another worksheet? | Excel Worksheet Functions | |||
Hybrid Mode
