Thread: List Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_67_] Bob[_67_] is offline
external usenet poster
 
Posts: 6
Default List Value

hello,
I have a unique list of City and States as follows
Col A Col B
City State
Boston MA
Quincy MA

Albany NY
Buffalo NY

I want to perform this scenario: Col A is a drop down box with all the
Cities. When user selects from the drop down City Boston, MA fills out in col
B. If the user selects Albany, NY fills out the next cell on the right of
city in col B. It will make it easier for the users, because right now therer
are a lot of wrong mapping from the users end.
Your help is very much appreceated as always. All the posts have been very
helpful to me.
Thank you
Bob



--
Bob