What I want to do is click a vendor from a drop down list. When the vendor is selected, I would like the following to auto complete in their appropriate blank cells: street address, city/state/zip, phone and fax.
I have set up my page to the look I want as sheet 1. Sheet 2 is the list of vendors being column A is the names that are indicated in my drop-down list.
Column D is the street address, Column H is the city/state/zip, column M is the phone and Column Q is the fax.
I have no idea how to make this happen... Any help would be great... And I am not too keen on all the Excel functions and lingo...
Thanks..
Kevin