| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using drop down lists
I have a drop down list of recipes. How can I set up the drop down list so
that when a recipe is selected, all the ingredents are listed in a separate sheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using drop down lists
Tie it to a macro that does that. Possibly thru a worksheet_change event
-- Don Guillett Microsoft MVP Excel SalesAid Software "supercalifragilisticexpialidosiuos" crosoft.com wrote in message ... I have a drop down list of recipes. How can I set up the drop down list so that when a recipe is selected, all the ingredents are listed in a separate sheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using drop down lists
We would need to know more about the worksheets.
Hopefully you have something like: Recipe_name, ingredient _1, ingredient-2, etc The you could use a simple VLOOKUP on the new sheet to extract the list Send me file if you wish (but my magic umbrella is leaking) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "supercalifragilisticexpialidosiuos" crosoft.com wrote in message ... I have a drop down list of recipes. How can I set up the drop down list so that when a recipe is selected, all the ingredents are listed in a separate sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
| How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Linear Mode
