S
SAL
Hi All,
I have two sheets where the first one is like a summary/dashboard and the second sheet contains the main data. In the second sheet each employee is mapped to 2-5 rows (these rows contain application names- each user has a unique applications):
User1 ApplicationA
ApplicationB
User2 ApplicationC
ApplicationD
ApplicationE
The first sheet uses dependency lists.. so when I select User1 I only see the relevant applications in the drop down list- ApplicationA, ApplicationB (each user's application have a defined name).
My question is how can I make the list of applications dynamic? For example, if I add ApplicationX to the User1 I'd like to see it in the drop down menu as one of the options for User1. As in ApplicationA, ApplicationB, ApplicationX
Any help is greatly appreciated. Thanks in advance
I have two sheets where the first one is like a summary/dashboard and the second sheet contains the main data. In the second sheet each employee is mapped to 2-5 rows (these rows contain application names- each user has a unique applications):
User1 ApplicationA
ApplicationB
User2 ApplicationC
ApplicationD
ApplicationE
The first sheet uses dependency lists.. so when I select User1 I only see the relevant applications in the drop down list- ApplicationA, ApplicationB (each user's application have a defined name).
My question is how can I make the list of applications dynamic? For example, if I add ApplicationX to the User1 I'd like to see it in the drop down menu as one of the options for User1. As in ApplicationA, ApplicationB, ApplicationX
Any help is greatly appreciated. Thanks in advance