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?
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Using a dropdown list to add multiple rows of data
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?