Can Form 8815 Dependent 2022-2023

Instructions and Help about Can Form 8815 Dependent

Okay so this is gonna be my next and hopefully the last video about dynamic dependent drop-down lists and if you did watch the other drop-down list videos you've probably seen how I made this project where I have this drop-down you select one of these brands and then you have basically the models that show up just for that particular brand so if I go here to this tab this is basically the way it's laid out we have this friends here in our C column and basically on the right we have the models and depending on which one of these makes we select so if we go with Ferrari we should only get models that show up over here so if I go back here and select this you're gonna see that the drop-down only has those models from that particular make now the challenge with this particular way of doing this is that this is only going to work if you just have two boxes side-by-side that you're trying to use this for but if you're trying to do this for the whole column so you want to have this whole column to work the same way when you select a brand then you have the models for that brand next to it this is not going to work and to make something like this we're gonna have to use app scripts now this is gonna be a pretty fun video for me because I haven't done this before but should be a problem using app scripts to get this done it is also probably gonna be a long video but if you know this channel you know that's not new it happens all the time anyway so let's go ahead and get started so the...