Hi all,

Is this even possible?

On a separate worksheet (#2), I created a list of address:

A1 = Mrs. Jones
111 Main Street
A-Town, NY 11111

A2 = Mr. Smith
222 Main Street,
B-Town, NY 22222


i want to create a drop down list on my cover letter, listing Mrs. Jones and Mr. Smith.
When i select Mrs. Jones, i want her address to populate. The same for Mr. Smith.

This is something i want to do for a long time but never had the patience to try. I just want to get it done.

Any help is greatly appreciated!!
Thanks,
Mark