Copy specific records from a worksheet to another

[Irfan]

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.

 

[CLR]

Data > Filter > AutoFilter should filter the results you want.........then
just copy and paste to the new sheet..........

Vaya con Dios,
Chuck, CABGx3

 

[Irfan]

Thanks. However, is their any way to do it automatically using vb script.

 

[Gord Dibben]

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