Hi,
You may refer to question 7 of
http://ashishmathur.com/knowledgebaseII.aspx
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"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.