filter a particular data

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
 
J

Jeff

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent list in excel to create validation 1
Summarise data on multiple sheets 1
Filter a Drop List ? 1
VBA: How can I use a string variable as autofilter criteria? 4
Filter and copy question 3
Where is pivot table data? 1
Lists on different sheet without using the filter. 5
Filter data 4

Top