View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sparklydaisy sparklydaisy is offline
external usenet poster
 
Posts: 2
Default Excel 2003 - Drop Down List

Hi There,

I was wondering if it is possible to have a drop down list put values into
different cells?

For example: Down down box lists 10 different locations. When a location
is selected I'd like to have several other fields in the same spreadsheet
filled with related data, based on the location selected. (for example:
Address, City, Postal Code.)

Any help would be appreciated. Thanks!

Gloria