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!
|