Select Multiple Criteria From Validation List Dropdown (populate Same Cell)
Aug 8, 2012
I have a validation list drop down box set up to reference data in a defined name list. I would like to be able to select multiple values from this list to appear in one cell (preferably separated by a comma). For example, the defined name list contains the following data:
Choice 1
Choice 2
Choice 3
Choice 4
I would like to be able to populate one cell with the following via the drop down list: Choice2, Choice 4
Is this possible and if so, how?
View 8 Replies
ADVERTISEMENT
Jun 1, 2014
It is basically a simple sheet that lists the price (Column C) of different items (Column B) based on their Category (Column A).
I am trying to have an automated pricing sheet (on different sheet) utilizing data validation and drop down lists.
For example each row should have this, the drop down list in the first columns should list all the Categories available (This part works fine for me and i can take care of the duplicates).
Once that has been selected, i have now the option of selecting using drop down list also (in second column) the items corresponding to the Category selected in first column (Only the items that are part of that specific category should be listed in the drop down list).
Once the item has been selected, the price of that respective item should be listed automatically in the 3rd column.
View 1 Replies
View Related
May 26, 2013
I would like to be able to choose a Size from a drop down list.
After choosing the size, the Parts and Price records (rows of data) will populate below a few cells.
I will manually insert the Quantity amount of items I need,
This will calculate the total from the cells (price & Qty).
View 7 Replies
View Related
Feb 7, 2012
So, I need to figure out how to make the populated contents of a single dropdown box dependent upon the selected results in two other drop downs.
As there are ~35K lines in the sheet, creating Lists is impractical, and VBA is out due to client security settings.
My data sort order is: Region Name > Area # > Facility Name
I have a drop down to select the Region I want to work in.
The drop-down for Area # populates based on the selection from Region Name.
The hang-up is that the area numbers are 1-4 for each Region.
So, I can't simply populate another drop-down for Facility from the result from Area #, but it has to be based upon the results of both of the former results.
View 4 Replies
View Related
Feb 4, 2014
I have created a DAta Validation List and it only select one item. I want it to select as many items that is on the list but i can't get it to work for my main worksheet I am working on. I can't figure out why I can't get it to work for the work sheet "This Don't" but it works for the worksheet "This Works" why and how I can change it so both Reason (Column F and H can) select mutliple items on there. Data Sheet.xlsx
View 2 Replies
View Related
Jun 7, 2014
I watched a video on youtbe. And the women had three or four items in drop down box. She was using vba. When i emailed her to ask her how she did this, she kept telling me to go to her website and i was supose to figure it out on my own. I am trying to do a start up construction company. the link to her site is as follows Select Multiple Items from Excel Data Validation List - YouTube the idea of what i want to do, is how she clicks on a word and it follows in the coloumn to the right going down. This is what i need to know how to do. It is probably pretty elementary to many of you. But i build, i know how to read prints, to cut footprints for new homes etc. But when it comes to excel i am so green.
View 2 Replies
View Related
Mar 7, 2013
[URL]....When I select a name in column B, it populates column C's dropdown with that name's list of units. When I select a unity type in column C, I'd like it to automatically populate column E in the same row with the value associated with that unit. The values associated with a particular unit can be found to the right of the sheet. So if in row 2 I select Blake in column B, then Unit 5 in column C, I'd like column E to be populated with 14.
Edit: using Excel 2007.
I attached stripped down version of the sheet which is small enough to post. None of the things I removed should affect the topic at hand. The full sheet is available at rapidshare.
View 6 Replies
View Related
Dec 19, 2013
Is it possible to have an in-cell drop down list to select a value from, while still being able to enter free text?
View 2 Replies
View Related
Jan 8, 2012
I have a workbook with 4 drop down lists. The selection in list 1 determines what is shown in list 2. I wish to have list 3 dependant on list 1 also, but don't know how to associate 2 drop down lists with the same previous cell.
The first list is in cell C2 and the table of data needed for list 3 is AC8:AC27-AO8:AO27,including the column titles.
View 2 Replies
View Related
Sep 28, 2012
I was just given a task at the office of creating a in depth excel spreadsheet. Here is what I need:
I have one drop down list that represents the state a person lives in.
I have another drop down list that represents the the type of property it is.
If you select CA in drop down 1 and Multi Family in drop down 2 you get the end result in (specific) cell.
Then if you select AZ in drop down 1 and SFR in drop down 2 you get different end result in named cell.
How can I get items within 2 different drop down list to call up the end result in a 3rd cell?
View 1 Replies
View Related
Jan 6, 2014
I have a complicated situation with Excel since I need a formula that can SUM data from the Pull 1 worksheet into the summary Sheet. I attached my sample for your reference because it is a bit complicated therefore I can not explain. It is better if you look at my Summary Sheet, need formula that can retrieve the same information.
Formula Test.xlsx
View 3 Replies
View Related
Apr 8, 2013
I have a spreadsheet where user can search for information inside a search box and the appropriate rows are returned using formulas.
I have a drop down list (Category: Model) in the search box as well as a search field (Category: Program, cell D2). Underneath the search box, search rows are returned with column categories: Program, Model, etc.
What I require is that if a user enters the specific program into the search field D2, then the dropdown list would automatically choose which model that program belongs to based on the returned row.
For example, if I typed "engine" into D2 and pressed enter,
Under the records section (Row 14 and beyond), the following record will pop up:
Program
Model
Indicators
Engine
F-16
3a
Based on the record, F-16 would be chosen from the dropdown list. Is there any way this can be done?
View 6 Replies
View Related
Jun 11, 2013
I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
View 7 Replies
View Related
Dec 7, 2006
I think the best thing is to take a look at the attached, then read what I'm looking for, as it would make more sense...
That being said: what I am looking to do is change cell L3 based on new criteria in cell M3.
Right now if B3=Stationery World then L3=Stationery.
What I then want to happen is if E3=Toner then M3=67200 which then has L3=Equipment Consumables and NOT stationery.
View 9 Replies
View Related
Jul 7, 2014
I've been trying to get a table to populate based on a couple of criteria. However, I've not come-up with the solution yet.
I have my dropdown selections in cells C2 & C3. The objective is to populate the table below the dropdown with data from the sheet named (very unimaginatively) 'Data'. Currently you see the selection AA-11 & Mar-14 in the Contract ID & Month cells. If I change this, the table below should auto-populate.
I've attempted using Vlookup, Index-Match. But it does not give me the desired result.
Also, the number of Products can change each month (although the file shows 4 for each month & each Account).
View 4 Replies
View Related
Oct 28, 2011
I'm looking for a way to get a unique list from a column to a data validation drop down list. Any fancy formula or vba script to create a UDF which. Does this?
View 5 Replies
View Related
Mar 18, 2014
I have a drop down list with 6 recipes. When I select chocolate for example I want that to automatically populate different cells in the worksheet based on a standard I have created for that recipe. The recipes won't change they just have different ingredients and I want that to show up depending on what I select on the drop down list. I went into VBA and worked a little with this starting code:
If Target.Address = "$F$3" Then
Target.Offset(0, 1).Value = "1"
but It wouldn't populate separately based on what I had selected in the drop down it would just populate all 6 recipes the same.
View 4 Replies
View Related
Dec 16, 2013
I am looking to auto generate a roster/schedule. I have a spreadsheet with shifts for each weekday that I need to populate every week with names to pick from a drop down list. the drop down list is made using data validation and looks at a dynamic named range to allow me to select only the people who are available to work a certain shift.
Is there a way to do this using vba?
View 3 Replies
View Related
Feb 25, 2014
I have a list on one worksheet and I use a dropdown list from Data Validation to select the name required.
My list is so long that I would like to be able to type a letter or two to access to the name quicker instead of scrolling down.
I copied a formula that worked for someone else that put this formula in the data validation
(IF(I36<>"",OFFSET(Player,MATCH(I36&"*",Player,0)-1,,SUMPRODUCT((MID(Player,1,LEN(I36))=TEXT(I36,"0"))*1)),Player))
I do not wish to use VBA is possible.
View 1 Replies
View Related
Mar 6, 2013
I have a query with data validation.....
Can I have a cell rage.. say A2:E20...and every cell in it has a drop down data validation list, from data inputted into L2:L27 (For examples lets say L2 is A, L3 is B, L4 is C, L5 is D and so on).
if somewhere in the range A2:E20, say B6 I was to select D from the drop down list, I want the remainder of the cells in range A2:E20, to have the drop down list without the value D in it, and so on, so the more cells in the range I fill from the list, the list for empty cells gets smaller and smaller until there are none left.
View 4 Replies
View Related
Jun 13, 2013
i created a drop down list from data validation and it's a list of names. as i select from the list of names, i just want the initials of the names to be shown, not the entire name itself.
cnf_gif.gif
cnf.gif
based on this example, what i want is to select from the list of names and only the initials are shown!
i believe its something related to custom number formats...
View 5 Replies
View Related
Jan 29, 2012
Is it possible to part fill a cell with some prepared text from a list or similar, but still allow the user to finish off the sentence?
Using a drop down list in A2, I want to have a drop down list in B2 so the user can select from that list, (B2 list is specific to A2 drop down list)
I want the user to be able to add to that selected entry when they have picked it from the list in B2
IE: from the drop down list in B2 = "To be or not ......" I want the user to be able to finish the quote
View 2 Replies
View Related
Jan 21, 2013
How to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.
Attached files for reference :
Dropdown Month.xlsx
MONTHLY DATA.xlsx
View 3 Replies
View Related
Mar 14, 2014
I have a very detailed spreadsheet with drop down lists. I would like to block other cells if previous cells have certain selections. I have 7 columns of data that get inputted throughout the month. These cells have drop down selections that I have created. Is there any way to create a drop down menu AND another data validation? So If a selection is made, then the next cells will be blocked, using data validation "custom"?
View 2 Replies
View Related
Sep 11, 2013
I have giant excel spreadsheet that I am trying to clean up. I want to make one of the columns (with around 3000 rows and may of them are the same) into a drop down list. However, when I try doing so from the data validation tab, I get duplicates, triplicates, etc. of the same item.
View 1 Replies
View Related
Sep 12, 2012
I am in the process of creating a database, and have used 'Data Validation' to create drop down lists in order to obtain information quickly from the database.
I have encountered an issue where if I have a list the resembles the one shown below, the drop down list will show spaces.
This is particularly an issue for myself and my database because there is over 1,000 items in the list, and there are countless empty cells within the list. I have tried sorting the list, BUT because the database is quite large, sorting it will disrupt other functions of the database.
Ideally, I would like the drop down list to show only entries within the list that are not empty so the drop down list is entirely relevant, and more user friendly.
View 2 Replies
View Related
Mar 23, 2014
When it huge list of data for drop down list, it is too much time consume. If i type a letter, it will show all those quarry or data which start with that letter. It need not to scrolling huge list.Scrolling is barrier for use of data validation for me . I tried all dependable data validation.
View 1 Replies
View Related
Jun 30, 2008
I have a data validation in a cell that works like this : if a control cell has the value "F" it validates the input with some dates in a custom list, if not it does nothing.
The formula looks like this :
=IF(F2="F",datelist,"")
It works fine but I also want it to display the drop down list when cell F2 = F, now all i can do is type a value and it checks if it's ok.
Can I do this without using vba ? I will send this to other persons and I don't want the macro warning to pop up when they open it.
View 9 Replies
View Related
Oct 27, 2006
I want to make some of my data validation dropdown lists narrower, so they end at the length of their longest list entry.
I know NOTHING about VB and although I found some "free code" online that claims to do just what I want to do above, I have no idea how to paste it in or where to paste it in, etc.
View 9 Replies
View Related
Sep 11, 2013
I have two worksheet. One worksheet is a form where in the Field Door No. should be a dropdown list. The list will be retrieve from worksheet Source. Now upon selecting a specific Door No. it should also autopopulate the respective Type, Brand, Serial No., and Type.
First thing i need to know is what should i do on Cell B1 worksheet Form for it to be a drop down list retrieving the Column A on worksheet Source.
Second, upon selecting for example ATC0009 on the drop-down, it should auto-populate like these
Door No. ATC0009
Type AT Crane
Brand A
Serial 43679
Type Crane
View 14 Replies
View Related
