View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BrownsFan BrownsFan is offline
external usenet poster
 
Posts: 8
Default Automating Address Information based on selecting data via a validation list

I would like to know the easiest method for populating mailing address
information based on selection of data from a validation selection
list. In column A, I have a validation selection list with one of
several 2 digit city codes. For instance, CL for Cleveland. After the
user selects CL, I would like Cleveland to populate Column B, Ohio to
populate Column C, and 44312 to populate column C.

I appreciate any help!