Question

Locked

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
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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums