Okay, so in this video, we'll make a dependent drop-down list. Let me show you what I mean by that. So, I'm gonna go ahead and name this tab "lists". Okay, that took longer than I thought it would. There we are. So, I'm gonna make a new tab. I'm gonna call this "main". So, this main tab, what I want to do, I want to have a drop down like this. And the first drop down is gonna be the "make". So, I want to be able to choose between different makes of cars, like Toyota, BMW, or whatever else is in here, and have it drop down for that. So, once I choose, let's say Toyota, I want to be able to choose the model in the next drop down list. But once I select Toyota in the model drop down, I should only have Toyota models. But if I select BMW, I should only have BMW models and so on. And that's gonna be what we'll be making in this video. Now, a couple of concepts we have to understand to be able to do this. I'm gonna cover first and then get back to actually doing the drop down. The first thing we'll have to do is understand what a named range is and how we can actually use that. So let's say I have some numbers here. If I try to sum up these numbers, I'll do equal sum and then I'll sum up these numbers right here, and I'm gonna get my total 126. Now, another way to do the same thing is I could just name this range. So, I'll highlight the range I'm planning to use, and I'm gonna right click and then in my list of options, I have "define named...
Award-winning PDF software
Video instructions and help with filling out and completing When Form 2220 Dependents
