I have an Excel table with a worksheet called “Vendor” containing vendor information going across columns, A=Vendor name, B=address, C=city, etc. On another sheet named “Form” I have a form with four rows in the same column into which I want to place a dropdown list with vendor names, and when I select a vendor I’d like the vendor information (address, city, country) to be added automatically in the rows below.
Row1=Vendor name
Row2=address
Row3=city
Row4=country
I have no experience with Excel macros or vba, just some macro/vba with Access. How can I do this?
