Consolidate Dropdown Lease For Free

hello and welcome to this video tutorial from computer ggar.com in this video we will have a look at how you can create multiple dependent dropdown lists in Excel to assist your data entry so drop down this to great they provide a very easy way of entering data but more importantly it will be accurate data however if you have quite large list You may wish to break that down and provide multiple kind of lists for selection but the second third and fourth list or so on however many you need would be dependent on the selection from a previous list so once we've created a list for list one here you know the options in list two will be dependent on what somebody has chosen in list one and then so on the options in list three will be dependent on what they chosen this too now on the other sheet of our spreadsheet here I have already set up some lists as an example so the first list will be a list of categories of product similar to what you would find on Amazon and then I've got the other list so if somebody choose books I'll get this drop down list of romance travel on Computing if somebody selected films they'll get this shop dentist of different film genres and so on they are broken down even further as to if they choose books and then choose romance they'll get this selection of books now for what we are going to do to work we need to create a range name for each of these little list groups that has been set up on this sheet or that you would like to use now I've taken the time to do a lot of them ahead of this video so that I can just show creating a couple of them to get ourselves going and you'll notice I've got this romance one selected at the moment E2 to E4 and in the name box in the top left it is called romance and if I select these games cells is known as games so I've just used the same name that I've got in the header there for Simplicity I can name it whatever I want but I've used a same know as header now what is important absolutely vital important for what we are about to do is that the name we give to the range has to exactly match the option in the previous list so in this category list the option is called games and the name of the range is games so that has to be bang on the same I can't have the category saying computer games and then the range name called games has to be bang on the same as they will be matched up for these dependent list to work okay so let's have a look at creating a range name in case this is new to anybody uh watching this video so for this category list I will select the ranges A2 to A4 and all we need to do is simply click in this name box in the top left here and type in what we would like to call it so I'll call it category and press enter on the keyboard to confirm and I'll need to do the same here for this books one and as I just mentioned we will need to name that books I need to match what is called in the category here so I'll highlight the range of sales with book items in click in the name box...