View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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?