dependent list

Students names ( on normal cells) changed automatically when i select a class from dropdown list : How can i do this via formulas or via vba? for example: "dropdown list " : [Class 6-1 Class 6-2 - Class 6-3 ] Student name 1...

Hi all, Was recommended to visit by a colleague whom people here had previously helped somewhat massively, hoping you won't mind me asking for your assistance as well! I'm almost certain that this is a really stupid, obvious thing I'm doing wrong, but despite a lot of Googling, different...

Hello friends, I'm using Excel 2013 and I'm trying to create some drop down lists like in the following example: https://www.youtube.com/watch?v=rLRrYPsxGa4 Here, when i'm choosing the city, let's say London, i would like to see all employees from London city, in a clear list, not in a drop...

Hello All, I have scoured the google for an answer and I can't seem to find out. I have read many posts to create data validation lists and then dependent lists but those always take into account that the information is in nice columns. How about when your source data is arranged by rows...

I'm using the following code to clear different lists in different cells: However, all of them work except for If Target = Range("T5")... which clears all the data validation lists instead of just T6 and T9. Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target =...

I'm trying to create a form or dependent list or ??? that will ask the user to answer a series of yes/no questions displayed one at a time. The subsequent questions will be determined by the previous answer. There will be approximately 15-20 questions, however a lot of the questions will be...

Hello :) I know how to let the user add items to a data validation list but in this case i need to do it to a dependent list and i donnow how to change the code :S str = Target.Validation.Formula1 str = Right(str, Len(str) - 1) Normally str should get the list name and the code would run...

Hi I hope you guys and girls can help. I am creating a template for some colleagues. In the template, the user will select an account from a drop down list (say the list is in A1). Then a few lines below (A5-A50), any sub accounts which relate to the account selected will appear. So it's...

Message Board, I am trying to create several dependent dropdown lists within an excel table. However all the tips/tricks that I have been able to find on this subject only refer to creating dependent dropdown lists in cells not incorporated into a table. For example, I would like to achieve...

Hi all, How would I create dependent lists? E.g. Column A has a list, and based on the selection in the list, I would like Column B to show a dependent list. So, if I select Animals from the list in Column A, in Column B, the dependent list shows different animals; however, if choose Birds...

Hi Although the title seems to hint towards creating dependent data lists (as in, if user selects state "CA" from a drop down in Column A, then the available choices in the drop down for Column B is retricted to cities in CA). My issue is a bit different. Here's what I have, I have 3 columns...