use datafilterautofilterfilter on "Manager"(note your SPELLING
BELOW)copy to the other sheet. Record a macro while doing.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sudipta Sen" wrote in message
...
In the Sheet 1 I create a List of with their datas, suppose,

Manager Rs. 10000
Customer Care Rs. 5000
Accountant Rs. 3000
Accountant Rs. 2500
Manger Rs. 7000
Customer care Rs. 6000
Manager Rs. 8000

I need only the Manager Data in the Sheet 2,

and I will reentry the all type data in sheet 1, new entry of Manager Data
only will come in sheet 2 automatically, and update.

How I could do it.