Excel 2002 dropdown lists
 

I've created a dropdown list showing each of our customers. Each customer has
several locations, so in another dropdown list I would like to show those
locations based on what customer was chosen in the first dropdown list. For
example, Customer 1 is chosen, I would like the Location dropdown list to
show only locations for customer 1. Is this possible?

Excel 2002 dropdown lists
 

try it

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

hth
regards from Brazil
Marcelo

"projectmgr" escreveu:

I've created a dropdown list showing each of our customers. Each customer has
several locations, so in another dropdown list I would like to show those
locations based on what customer was chosen in the first dropdown list. For
example, Customer 1 is chosen, I would like the Location dropdown list to
show only locations for customer 1. Is this possible?

Excel 2002 dropdown lists
 

This page might be better <g:

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

Marcelo wrote:
try it

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

hth
regards from Brazil
Marcelo

"projectmgr" escreveu:


I've created a dropdown list showing each of our customers. Each customer has
several locations, so in another dropdown list I would like to show those
locations based on what customer was chosen in the first dropdown list. For
example, Customer 1 is chosen, I would like the Location dropdown list to
show only locations for customer 1. Is this possible?




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