Multiple cell drop down list
I am in need of your big help!
I want the cell to generate drop down list if certain conditions are met.
To simplify, cell need to return a "list" if other cell 1 & cell 2 are true or equals to or contain specified"" text either from other list or values.
Please take a look at image below and help me!
12-27-2011 2-37-08 PM.jpg
How do you select multiple characters in a drop down list to appear in one cell? Mainly, displaying multiple values or words after selecting more than one choice from the drop down box so they can be displayed in the one cell that the drop down box is located in.
so be patient with me.
I know how to create a drop down list - see attached.
The first drop down list shows the horizontal values on "Food List" tab A1 through to I1.
What is want to do is this:
* When I select the first drop down list it shows me the horizontal selection.
* When I select the choice i.e. "Grains", it shows a second drop down list showing all of the vertical selection underneath that heading, i.e. C2 to C9.
How do I create this second drop down list?
I am trying to figure out how to create a drop down list that is connected to multiple formulas. The basic way it will work is the far left column will have the drop-down list. There will be 6 columns to the right and every column will have a different formula. Every selection in the drop-down list will use a different set of formulas. Does anybody know how to do this? Let me know if I didn't explain this very well.
I have a multiple names in sheet 2 column 1 (approx 12)
I want to be able to select multiple items from a drop down list in sheet 1 and populate them all in one cell, separated by comma, or semi colon.
The drop list will also auto update if any name is later added in the sheet 2.
Related Applications & Scripts
This is a jQuery plug-in, which helps to make beautiful sliding drop lists available in 6 color schemes.
Mega Menus refer to drop down menus that contain multiple columns of links. This jQuery script lets you add a mega menu to any anchor link on your page, with each menu revealed using a sleek expanding animation. Customize the animation duration plus delay before menu disappears when the mouse rolls out of the anchor.
The ComboBox can be configured to allow selection of multiple options, but in this case a list of options with CheckBox is much more intuitive for users.
CodePeople List transform ComboBox with multiple selection into a CheckBox list, and also to allow the incorporation of new options that are not part of the initial listing.
- XML driven menus
- Supports multiple categories and unlimited items
- You can choose to target a URL and/or frame inside a movieclip, method and target set in XML
- You can set menu spacing, max number of items to be shown before scrolling, tween speeds etc. in the script
A file upload application, with the added benefit of the drag and drop functionality. Allows users to quickly and easily upload multiple files to your server by dragging & dropping them into the drop box or select files via the traditional uploader pop up, and have on-going access to them for download/sharing/modification/removal. Each upload boasts a full complement of sharing icons so files can be easily distributed to an unlimited audience at the click of a button.