Dynamic List Range

**sarah112** · 07-31-2013, 05:53 PM

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

**Pauleyb** · 08-01-2013, 11:58 AM

I think it can be done. It would be hard to describe in the forum as it is likely a multi-step process. This is the page I usually visit when I want to do some tricky drop boxes. Look in the Data Validation section.

http://www.contextures.com/tiptech.html

**Munch5** · 08-01-2013, 09:28 PM

Was thinking of a few ways to do this, but then realized that maybe I was over thinking it. Can't you just use a pivot table and just refresh it as you add more applications to a given user?