Using a dropdown list to add multiple rows of data

By zdjbel ·
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

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.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums