Select a category from a list that populates related cells

J

Jules73

Hello, i am trying to set up a drop down list on a form that looks up a
column on a table and populates 10 linked cells from the row on the table
into the form with the drop down.

Example.

If I pick "Eggs" from a drop down list on a form it should fill the next 10
cells in the row with the following numbers on the table below into the form.

Product Cost1 Cost2 Cost3 Cost4 Cost5 Cost6 etc......
Eggs 1 2 1 4 3 3
Bacon 2 2 2 1 3 1
Beef 4 3 2 4 4 3

The Form would look like this after I have selected "Eggs"

Product Cost1 Cost2 Cost3 Cost4 Cost5 Cost6 etc....
Eggs 1 2 1 4 3 3

Ive looked at lookups, lists Validation drop downs but i Cant make it all
work together. Can anyone help??

Thanks in advance.
 

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

Cost Rate Table Macro request… 5
Limit drop down items based on another cell 3
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Unable to display values in 2nd list box from 1st list box selection 2
Merging from an Excel file with graphics 1
Need help referencing b/w sheets for school project 0
Data Validation - Conditional List 3
dependent, multiple variable, drop down list 2

Top