Show content depending on whats chosen in dropdown

Hi,

I have the attached list which is the sheet we use for showing who has vacation and when.

The columns represent persons, and rows the dates.

In sheet 2 i have assigned everyone to teams, and would like to be able to have a dropdown in sheet 1 where you can pick between those teams, and then have only those people within that team show up.

How is this possible?

Hi,
One options might be:
- make sure all names in both sheets are the same (employee names)
- create ActiveX combobox with team names
- write code for combobox change event:
After you choose name of the team you need to find coresponding column in sheet2
Then you should loop through all your columns in sheet1 and check if current name is in the list of employees in sheet2: if not - hide current column.