Dependent Drop Down Lists, or VBA Combo Box?

[mjninc]

Hello,

I am struggling with a spreadsheet I said I would make to help elementary school clerks. I have seen parts of my issue posted in various places, but I haven't been able to find how to tie it all together.

I need to create an Elementary School Scheduling Grid. I need to be able to

1. Select the Grade Level.
2. (*The selected grade level needs to only populate that grades' course numbers in the list drop down in E2.) Select the Course Number
3. And cell E3 be populated based off of the course number selection
4. And cell E4 be populated based off of the course number selection

I have attached a spreadsheet and I have two populated worksheets. One worksheet has the lists of information.

What do I need to do? Please help! Thank you so much!

ESG.png