Displaying different validation lists
 

In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists ("Activities")
depending on the choice made in column "A". For example, if a user selects
"Phase 2" in column "A", then the validation list in column "B" would display
"Activity E", "Activity L", and "Activity M". But if a user selects "Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob

Displaying different validation lists
 

You can create dependent data validation dropdowns, as described he

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

Since your first list has multiple word items, note the instructions in
the 'Using Two-Word Items' section.

Bob wrote:
In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists ("Activities")
depending on the choice made in column "A". For example, if a user selects
"Phase 2" in column "A", then the validation list in column "B" would display
"Activity E", "Activity L", and "Activity M". But if a user selects "Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Displaying different validation lists
 

See http://www.contextures.com/xlDataVal02.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bob" wrote in message
...
In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists
("Activities")
depending on the choice made in column "A". For example, if a user
selects
"Phase 2" in column "A", then the validation list in column "B" would
display
"Activity E", "Activity L", and "Activity M". But if a user selects
"Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob

Displaying different validation lists
 

Bob

See Debra Dalgeish's site for "dependent DV dropdowns"

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 18 Dec 2006 11:54:07 -0800, Bob wrote:

In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists ("Activities")
depending on the choice made in column "A". For example, if a user selects
"Phase 2" in column "A", then the validation list in column "B" would display
"Activity E", "Activity L", and "Activity M". But if a user selects "Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob

Displaying different validation lists
 

Debra - Thanks!
Bob


"Debra Dalgleish" wrote:

You can create dependent data validation dropdowns, as described he

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

Since your first list has multiple word items, note the instructions in
the 'Using Two-Word Items' section.

Bob wrote:
In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists ("Activities")
depending on the choice made in column "A". For example, if a user selects
"Phase 2" in column "A", then the validation list in column "B" would display
"Activity E", "Activity L", and "Activity M". But if a user selects "Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Displaying different validation lists
 

Bob - Thanks!
Bob


"Bob Phillips" wrote:

See http://www.contextures.com/xlDataVal02.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bob" wrote in message
...
In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists
("Activities")
depending on the choice made in column "A". For example, if a user
selects
"Phase 2" in column "A", then the validation list in column "B" would
display
"Activity E", "Activity L", and "Activity M". But if a user selects
"Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob

Displaying different validation lists
 

Gord - Thanks!
Bob


"Gord Dibben" wrote:

Bob

See Debra Dalgeish's site for "dependent DV dropdowns"

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 18 Dec 2006 11:54:07 -0800, Bob wrote:

In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists ("Activities")
depending on the choice made in column "A". For example, if a user selects
"Phase 2" in column "A", then the validation list in column "B" would display
"Activity E", "Activity L", and "Activity M". But if a user selects "Phase
5" in column "A", then the validation list in column "B" would display
"Activity Q", "Activity T", and "Activity Z".
Can this be done without macros? Any help would be greatly appreciated.
Thanks, Bob