Excel 2002 dropdown lists

[Guest]

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?

 

[Guest]

try it

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

hth
regards from Brazil
Marcelo

"projectmgr" escreveu:

 

[Debra Dalgleish]

This page might be better <g>:

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