Filter than sort...

[DButtgen]

I have a bunch of businesses, each with staff. Without using macros, how can I populate from a drop down with the business name, a list of the staff in order by tenure for that business?

 

[Marcelo Branco]

Hi,

Maybe this can help
http://www.contextures.com/xldataval02.html

M.

 

[DButtgen]

Thank you! This is close to what I am trying to do. In the example, if I click on fruit, how could I get all of the fruits to list down the page?