I would like a drop down selection (City) to automatically input a
predetermined street address into another cell (different street based on the
city selected). I think it's a macro associated with the change event of the
drop down. I can do vba but I need a suggestion as to what the vba would do.
Thanks for any help.