Is there a way to create a drop-down menu that you have pre-input names in that brings back the addresses for those names (stored in another tab) when you make the selection in cells below the drop-down? I basically want it to autofill the address in the correct line when I select that customer from a drop-down.
Bookmarks