i am try to make an invoice in excel that i can have a drop down box with numbers in 1 to 500 that when i pick one it will Auto Insert name & address form a spreed sheet i have with the name & address in it


Sorry if that do not make any sense as i new to excel


Many thanks