Fill date based on multiple drop down selections

[KOTZBROCKEN]

I am trying to have this excel doc fill data based on what is selected in the drop down lists on the heading page but i cant seem to figure out how to get it to be if zone 1 is selected as plank then the zone 1 rooms show up on the plank tab and then the sf quantity is shown next to the total not the sy quantity. I have gotten a few thinsg figured out like how to get it to pull the packages but not the rooms or quantities to the right tab in the work book. Any help on how to do this would be appreciated!

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...selection.html