Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select a category from a list that populates related cells
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select a category from a list that populates related cells
Ahh I figured this one out from T.Valkos reply earlier on Mithus thread.
Thanks!! "Jules73" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
Selection in 1st list box populates 2nd list box | Excel Worksheet Functions | |||
Count dollars in related cells | Excel Discussion (Misc queries) | |||
How do I select all values within a category in Excel? | Excel Worksheet Functions | |||
Search a worksheet and add related cells | Excel Worksheet Functions |