Eeyore11081
New Member
- Joined
- Oct 12, 2006
- Messages
- 1
Here is what I am trying to do with my mailing list:
Column A: Names
Column B: School
Column C: Street Address
Column D: City
Column E: State
Column F: Zip
I will be entering names manually into column A. I have created a drop down menu listing the schools in Column B.
My dilemma is that I would like to have columns C,D,E, F automatically populate with the appropriate contact information for the particular school after I select the school from the drop down list. (Note, I do have a worksheet which lists all the schools and addresses).
For example, I enter Joe Smith in column A and then select Hollywood High School from my drop down list in column B. Is there a way to program the sheet so that columns C, D, E, and F automatically fill in the appropriate address, city, state, and zip for Hollywood High School (from the other worksheet)?
Thank you for any help that you can provide.
Column A: Names
Column B: School
Column C: Street Address
Column D: City
Column E: State
Column F: Zip
I will be entering names manually into column A. I have created a drop down menu listing the schools in Column B.
My dilemma is that I would like to have columns C,D,E, F automatically populate with the appropriate contact information for the particular school after I select the school from the drop down list. (Note, I do have a worksheet which lists all the schools and addresses).
For example, I enter Joe Smith in column A and then select Hollywood High School from my drop down list in column B. Is there a way to program the sheet so that columns C, D, E, and F automatically fill in the appropriate address, city, state, and zip for Hollywood High School (from the other worksheet)?
Thank you for any help that you can provide.