Drop downs w/ pop ups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you program excel so when a user selects an item on a drop down list, it would also automatically fill in two other related fields. For example

On field A1 is a dropdown list of two products (Product A & Product B). When a user selects Product A for field A1, the item number for Product A will automatically show up in field B1 and the price for Product A will show up in field C1.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop Down List 3
Creating and Invoice with multiple dependent dropdown lists 2
Access Cascading combo/query in table/subform 0
Auto display all related info 2
Cascading combo/query in tables 0
drop down list should remember selection. 6
How do I show that a drop down list exists in a cell? 1

Back
Top