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.