vivalamike
New Member
- Joined
- Feb 20, 2014
- Messages
- 1
Hello,
I have 7 sheets of data, each relevant to location. Within these sheets are tables of teams. Each one is a team leader name and then a table showing their staff and shifts (monday - friday).
What I want to do is have a front sheet where managers can select their area from a dropdown and then their team, again from a dropdown....this I have done via data validation and linking the two
Where I am stuck is, how do I now link this selection to make excel display the table of their staff and shifts from the other sheet?
I have 7 sheets of data, each relevant to location. Within these sheets are tables of teams. Each one is a team leader name and then a table showing their staff and shifts (monday - friday).
What I want to do is have a front sheet where managers can select their area from a dropdown and then their team, again from a dropdown....this I have done via data validation and linking the two
Where I am stuck is, how do I now link this selection to make excel display the table of their staff and shifts from the other sheet?