filter a particular data
 

Supoose I creat a list of staff with therir designation.

Now I want to filter only 1 type of designation from the list, which will be
displayed on other sheet, means If I update list, it will automaticaaly
update on the next sheet with that particular data

How could I do it

filter a particular data
 

I would use a filter (advanced). Set up the List Range as the columns with
existing data, leaving plenty of rows for additional data in the future.
Select the Copy to Another Location option.
"Sudipta Sen" wrote:

Supoose I creat a list of staff with therir designation.

Now I want to filter only 1 type of designation from the list, which will be
displayed on other sheet, means If I update list, it will automaticaaly
update on the next sheet with that particular data

How could I do it

filter a particular data
 

Excel 2007 Advanced Filter
Jeff's idea, automated.
http://www.mediafire.com/file/qm2qtdjot2y/10_28_09.xlsm