filter a particular data

  • Thread starter Thread starter Sudipta Sen
  • Start date Start date
S

Sudipta Sen

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.
 
Back
Top