YTLE#75: DV Drop-Down based on DV Drop-Down

Hi there!

I have 2 cell dropdowns and I want the 2nd one to pull information from another spreadsheet (named range) based on the value chosen in the first dropdown.

E.g.

Dropdown1 : Values = Yellow, Green, Blue (these are linked to a name range which looksup from another spreadsheet).

Dropdown2: Values = Banana, Sand (if yellow), Pepper (if green), Ocean (if
blue).

So you won't be able to choose Green Banana, for example.

The problem I am having is that both dropdowns are getting the values from another sheet (we cannot change this - see below).

We originally had a direct copy of the 'data' spreadsheet in the 'lookup' spreadsheet, so we used =INDIRECT(SUBSTITUTE(B31," ","")) and gave each 'object' (banana + sand, ocean etc) its own name.
This worked fine, but the problem we found was that if the 2nd spreadsheet was to update then we would have to duplicate the changes in the 1st spreadsheet.. This caused lots of problems and had a massive risk of user error.

We need to have the 2nd spreadsheet in place because other departments use it.

Please help!

Sorry if this makes no sense at all!! Let me know if you need more info.

Cheers,

James

Hi all,

I have the following data in a sheet. The first drop down box has data in column A. On the second one, I would like to show the database based on the selection made in column A i.e. If I have selected Resort 2, I would like to see only Hotel B etc..in the second box.

Resort 1 Hotel A Hotel AA Hotel AAA Hotel AAAA
Resort 2 Hotel B Hotel BB Hotel BBB Hotel BBBB
Resort 3 Hotel C Hotel CC Hotel CCC Hotel CCCC
Resort 4 Hotel D Hotel DD Hotel DDD Hotel DDDD

I am just wondering whether there is an easy way to do that please?

I would extremely appreciate if someone can help me on this.

Many thanks,

Hi Mr. Excel..

Im trying to figure out how to combine to dropdown lists, based on each others value.

Fx. I have two dropdown lists.
1) list of building components as door, window, wall etc.
2) SfB numbers as 31, 32, 33 etc.

I want list 2, with the numbers, to change when I choose ie. door. So when i choose door in cell a1, b1 will auto fill out with the number 31.

I hope you can help.
Thanks, Mathias

Hi All,

Sorry if the title doesnt make much sense, it was hard to think what to write!

So...

I have a workbookk whereby there are a number of questions with drop down boxes to select the answer. I set the drop down boxes up by selecting data > vailidation > list and pointing it at the list of possible answers. But i dont know how to make the second lot of possible answers dependant on the first answer selected.

So:

1. Incident Type? [Drop down with possible answers]
2. Failure Type? [Drop down with possible answer for the selected incident type]

All the information is stored in lists on the same page (which i will hide). I have tried putting the source of the 2nd drop down list as an IF statement but it doesnt accept it.

I hope that makes sense.

Regards!

Hello:

This is my first post here, so please let me know if I am miss providing any information that would help solve my problem. I have the following need in Excel:

I have a dropdown list of 3 items in cell A1. I want to be able to add items in the dropdown list by entering them into cell A1, not by creating a dynamic range elsewhere. I am required to captured new items in the list as and when they are provided during a data gathering session, so when I come across a new item which is not in the dropdown list, and when I type that item in cell A1, that item should be the entry for cell A1 and also be added to the dropdown list of cell A1. Could someone please provide some detailed method to accomplish this? I have a deadline to meet today.

I am using Excel 2007. Thank you.

I have a dropdown box in cell C27 which has two values: Base and Deluxe. When Base is chosen I would like to hide row 31 on this page and row 53 on another and when Deluxe is chosen, I would like them unhidden. I have the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$27" And Target.Value = "Basic" Then
Rows(31).Hidden = True
Sheets("outputs").Rows(53).Hidden = True
Else: Rows(31).Hidden = False
Sheets("outputs").Rows(53).Hidden = False
End If

End Sub

I thought this was working fine, but a user came along and selected a range of multiple cells and deleted them, causing a type mismatch error (Target.Address is a single cell). Can anyone help in accounting for a user selecting and performing an action on multiple cells? I have been told now that new rows may be added to the bottom of the sheet at some point in the future and that will cause the same error.

Thanks

I have a bunch of data that's filtered. On a separate worksheet, I'm going to have a dropdown selection and based on that selection, I want my data to filter accordingly. I can handle the logic part of what to filter, if someone can give me a simple example of how this could be obtained. Thanks.

Hello all,

I want to implement the Date dropdown list and time dropdown list.

I can create a combobox with my own custom drop down list, but there has to
be built in drop down lists available... i.e. date.

How do I turn a blank combobox into a combobox that will allow the user to select a date from the dropdown list? Or even the little calendar that allows you to select a date from the calendar (like in an Outlook appointment)?? I looked into fields,but haven't been able to find how they can be applied to this. (I can get a control to display a field, but don't know how to get the dropdown list, or how to change the field using the control.) I also need a dropdown list with time.

Hi all,

I have an excel workbook and basically want a macro to hide the column when the word "Scheduled" is input in row 6 (Range C6:BA6)

For example, if column C6 has "Scheduled" I want this macro to hide the column when activated. The title of the sheet is "Sheet1".

Regards
Dave

hi, i am looking to create an interactive that will be based on what is selected from 2 dependent lists. I was wondering if somebody could help as i dont really know how to go about creating one.

thanks in advance.