Dymanic List Range

[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

 

[GS]

Redefine the ranges containing the application lists so they are
'dynamic' is all. (assumes you have this stored in ranges and have put
their respection location in the DV ref box)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

Oops.., typo correction...

Redefine the ranges containing the application lists so they are

'dynamic' is all. (assumes you have this info stored in ranges and
have
put their respective location in the DV ref box)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion