Hi All,

I have two sheets where the first one is like a summary/dashboard and the second sheet 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 application name):
User1 ApplicationA
ApplicationB
User2 ApplicationF



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