Create Default For Dependent Drop Down List

Feb 18, 2010

I'm using dependent drop-down lists. In the first box the user can choose a color which drives a set of options in the second box. (e.g. User selects "Red" and in the second dropdown they can then choose "Red A", "Red B", "Red C", etc.). Right now, if you select "Orange", it will still show "Red A" from the previous selection until the user selects the dropdown in the dependent box to refresh the list of options. Is there a way to make it so that second dropdown box will default to "Orange A"?

I tried writing some code to do this, but I can't seem to make it work. I've attached my file.

View 7 Replies


ADVERTISEMENT

Dependent Drop Down List With DEPENDENT DEFAULT VALUE

Jan 22, 2010

Situation:
I have two drop down lists 1) Country and 2) States/province

Country has list: [US, Canada]

If "US" is selected, [Arizona ,Florida, NewYork] is listed in the 2nd drop down list
If "Canada" is selected, [Alberta, Ontario, Quebec] is listed in the 2nd drop down list

Scenario:
First, I select "US" and choose the states to "Florida"
Next I change the country to "Canada" and forgot to choose province
Then, the 2nd dropdown list is changed to [Alberta, Ontario, Quebec],
BUT the current value is still "Florida"

Probem:
Now I have "Canada" and "Florida" selected in the sheet

Question:
If the primary list is changed, can I make the 2nd drop down list to show a default value (e.g. blank or the first entry i.e. Alberta)?

View 11 Replies View Related

Default For Validation List Dependent On Others

Feb 29, 2008

Two of them operate independently of each other, as in it doesn't matter whether a user selects yes or no, those are the two options. The validation list of the third question is dependent on the two others. Essentially if someone selects "No" to the first question, the only option for the third question is "N/A". If someone selects "Yes" to the first question and "Yes" to the second question, then they have the option of a yes/no drop down list. If someone selects "Yes" to the first question and "No" to the second, then the only option is "N/A." Here's my dilemma.

Since what I'm trying to create is going to be incorporated into a financial model that many people will use for to test a variety of scenarios, I'd like to make sure that the first option in the dependent drop down list (in question #3) displays automatically and changes if someone switches back and forth between different yes/no answers.

I've read how to get a dependent list to automatically populate the cell based on the selection in one cell (i.e. if question #1 is a "No", I can make the cell for question #3 populate with "N/A"). But since the validation list for question #3 is dependent on how someone responds to questions #1 AND #2, I'm not sure how to figure that out.

View 3 Replies View Related

Dependent Drop Down List Keeping Old Value

Apr 11, 2008

My problem is a dependent drop down list that keeps the previous value when a different value is picked in the first drop down list. The dependent drop down needs to change to empty/blank.

The first drop down list is in cell C3.
The dependant drop down list is in cell C4.
The source in C4: =INDIRECT(VLOOKUP(C3,allnames,2,2))

I had a look at various answers on the internet but somehow cannot get it to work (and that is more of a reflection of my own skills than the writers of those answers!).

View 9 Replies View Related

Reset Dependent Drop Down List

May 10, 2007

The only thread I could find on this topic was not resolved. I want to reset the value of a dependent drop down list (in H3) to the first valid choice when F3 is changed.

I have the following code that initially worked but no longer does.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Goto errHandler
Dim DLRng As Range

If Not Intersect(Target, Me.Range("F3")) Is Nothing Then
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
Set DLRng = ActiveWorkbook.Names(Target.Value).RefersToRange
Me.Range("H3").Value = DLRng.Offset(0, 0).Value
End If

exitHandler:
Application.EnableEvents = True
Exit Sub

errHandler:
MsgBox "Could not change dependent cell"
Goto exitHandler
End Sub

I now get the error message ""Could not change dependent cell" every time I pick a different item in the drop down list in cell F3. If I remove the error handler I don't get the error and the code simply doesn't work.

View 9 Replies View Related

Setting Default Values In A Drop Down List

Feb 14, 2007

I want to automatically set default values in a row dependant on the value chosen in a list. Some of the default values need to be lists where the user can chose to update to a non-default value.

I have tried using a double drop down list. However if the default list value is changed then the dependant list value is changed, the default list is not automatically updated.

View 4 Replies View Related

Create Dependent Dropdown List

Jun 10, 2014

Attempting to use INDIRECT function to create dependent data validation list (Type). The tricky part is that the drop down options are dependent on the values of two (2) cell values (Brand and Country).

I have used the INDIRECT function before but dependent on ONE cell value only.

Have attached an example to better explain.

Example.jpg‎
Example.xls

View 4 Replies View Related

Create Dependent Dropdown With Dynamic List?

Apr 1, 2014

I need to create a 2-stage dependent drop down list.

Stage 1:

In cell G7 (on a tab called 'Data'), I have created a drop down list based on a range name called 'Region' .

Stage 2:

In cell G8, I need to create a drop down list which is dependent on the value chosen in G7.

Problem is, I will need to create a dynamic range name here which needs to vlookup or match the value from G7 in a dynamic list of data (the data is on different tab called 'RCA Data' and is spread over columns A:E with row A for headings - the data will go down an undetermined number of rows)

Every time the value in G7 matches a value in the 'RCA data' (the potential matches are stored in column

D) I need the corresponding cell value in column C to be added to the dynamic list. This list then needs to be available to choose from a drop down list in G8.

View 1 Replies View Related

Create A Name List From One Sheet Dependent On Value Of Another Cell

Aug 4, 2014

I have a master list of names on sheet 1 column A. I want to create a list of names on sheet 2 column A of the people from Sheet 1 column A that have a specific value (Y) in column z sheet 1. I might also want to different numeric values for the Z column

View 7 Replies View Related

Create Dropdown List With A Range From Dependent Cell?

Oct 30, 2013

I have the following table with weeks to display for the holidays and my column H has a drop down list of the first column in the table below with the Named Range, "SNCODE.Season_Codes".

The other two Named Ranges are, "SNCODE.Season_Codes.Start" and "SNCODE.Season_Codes.End"

I need my column K to display a list of weeks from the first week to the last week. For example, the cell in column K for Valentine's Day should have 1, 2, 3, 4.

Basic 1 53
Promotional 1 53
Seasonal Spring 1 13
Seasonal Summer 10 26
Seasonal Fall 23 39
Seasonal Winter 36 53
Valentine's Day 1 4
Halloween 31 40
Christmas 36 48

View 6 Replies View Related

Using Data Validation To Create List Dependent On Multiple Rows?

Jul 28, 2014

I have three individual lists and I am using a formula like this for each of them =OFFSET(Table1,MATCH(F15,Table1,0)-1,1,COUNTIF(Table1,F15),1)

for my final cell I need to create another data validation list which is depenant on the values selected in the previous three lists.. how I would alter the formula to allow me to do that? I tried using and after the match to match all three tables but it never worked

View 12 Replies View Related

How Do I Create A Drop Down List

Dec 11, 2008

I do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.

View 14 Replies View Related

Create Drop Down List With No Blanks

May 19, 2009

I would like to create a list with reference to IF (E1:E150=1) list F1:F150
No Blanks. Cells E1:E150 will be either a 1 or a blank.
The new list will be created in cells Y5:Y whatever. List will then become a drop down list.

I have created the list but it has blanks between names and I just want the names....

View 9 Replies View Related

Selection From Drop Down Box To Create A List

Sep 13, 2006

is it possible to create a list of parts from a selection in one drop down box

ie
i have 1200 parts with descriptions etc in list . using a drop down box i want to select and create a workto list.

ideally this list would start on another worksheet starting on row 10

View 6 Replies View Related

Create A Drop-down List To Run Macro

Oct 19, 2006

I'm able to create a simple User form Drop-down list that references a cell range list. ( as a test for myself) I have 4 separate macros I would like to run individually. Rather than create 4 separate buttons, I'd like to be able to select each one via Drop-Down list.

View 4 Replies View Related

Create A Drop Down List With The Items In Column A

Jan 25, 2010

In Column A I have a list of Products and in Column B is the list of corresponding prices. I'd like to create a drop down list with the items in Column A that would automatically fill-in the pricing from Column B next to it. I've tried using an IF statement, but my product list is too long.

View 5 Replies View Related

Create A Drop Down List Based On The Value In A Cell

Oct 14, 2008

I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.

View 4 Replies View Related

Create A Drop Down List And Use Lookup To Get Corresponding Items

Nov 12, 2009

I am making a spreadsheet for food and calories, On sheet one i have a meal tracker, I want to have a drop down list in colum 1 that references the food list on sheet 2, column A=food, column B=Protien, column C=Carbs, column D=fat. The values from Sheet 2 columns B-D would then be inserted into Sheet A in the respective slots. I have fiddled with vlookup and tried numerous things but I can't seem to figure this out.

View 3 Replies View Related

Create Drop Down List For Worksheet Tabs

Mar 19, 2007

I have seen it accomplished where all worksheet tabs are arranged in a drop down list, and was wondering how to make that happen.

View 6 Replies View Related

Create Drop Down Boxes Based On List

Jan 29, 2008

My problem is i need to create a drop down box in excell, now i have a list of names,

Name 1
Name 2
Name 3
Name 4..........

I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!

Name 1
Name 2
Name 3
Name 4
Name 5..................

View 2 Replies View Related

Create Drop List That Populates Cell With Some Other Data?

Feb 4, 2014

I am trying to create a drop down list so that when the user choose Option A, Outcome A populates the cell.

So for example, I am looking to show a list of all Grades within the company, when the user selects a grade, the salary is populated into the cell.

View 7 Replies View Related

Create A List Drop Down With The Source Data From Another Workbook?

May 11, 2009

I have a spreadsheet called contacts which is as it says, I have another sheet called project management, I want to have a drop down list which refers back to the contacts spreadsheet, it this possible as they are two different files?

View 4 Replies View Related

Create Drop-Down List Using Increasing/Decreasing Range

Oct 3, 2006

I have a list of jobs being displayed using the following code. All sheet names that start with AJ, CJ and PJ within the workbook are how the list is created.

Sub ListSheets()
Dim sht As Worksheet
Dim lRow As Long
Dim rCell As Range

With Sheet1

Set rCell = .Cells(2, 12)
End With

For Each sht In ActiveWorkbook.Worksheets
Select Case UCase(Left(sht.Name, 2))
Case Is = "AJ", "CJ", "PJ"
lRow = lRow + 1
rCell(lRow, 1) = sht.Name

Case Else
End Select
Next sht

End Sub

what i want to do is create a drop list within each job sheet within the workbook that will display the names of the jobs above. Now the thing is I cannot choose the range like normal from data - validation - list as I will not know how many job names will be displayed so I dont know how many cells to include in the range.

View 6 Replies View Related

Create A Sub List From A Drop Down List

Jan 26, 2009

I need to create a 'sub' list from a drop down list.

I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.

And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.

View 9 Replies View Related

Macro To Create A Dialog Box For Entering And Updating Drop Down List?

Oct 31, 2013

This is what I'm trying to do:

1. When a user clicks on a Drop down box and selects "Add New", I would like a Macro to run

2. I want this Macro to open up a Dialog/Text box to say "Enter New Information" where the user can enter in some text

3. The text that is entered by the user into this box will be added as a new entry into the Drop down box selection

My VBA knowledge is still at a beginner's level and I know how to get a Macro to run based on a cell value. However I don't know how to create a Macro for the dialog box nor do I know how to create a Macro for updating the drop-down items.

View 8 Replies View Related

Dependent Data Validation - Set First Item As Default?

Jul 24, 2014

Is there any way when using dependent validation lists, that once a selection is made in one list, the next list will automatically default to it's first item?

So in the attached example, if Activity2 is selected in cell B7, then TaskC would automatically appear in cell C7 but the user can still choose a different value if necessary?

View 4 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Dependent Drop Down Lists ...

Jul 6, 2009

I have been searching on this for a little while now but have not been able to find a solution to my problem. I have been asked to create a series of dependent dropdown lists using excel so that we can use these for inventory imports into a asset system. The catch on this is that nobody here really has any idea on how to make these dependent lists reference each other correctly. The reason for that is because the fields all have spaces in them and I do not know how to get a list name with a space in it or to create the proper translation for it. An example of this would be something like what I have written in below ....

View 13 Replies View Related

Cell-dependent Drop-down

Oct 12, 2009

Say in A1 i have either Yes or No, in B1 i have a dropdown validation from a list if A1 is Yes and "n/a" if A1 is no.

I thought if i renamed my list validation to "Yes" and labelled "n/a" as "No", then using =INDIRECT(A1) as my list validation would do the trick.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved