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

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

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