I'm looking to create quality tracking spreadsheet and need to include multiple dependent drop down lists.
Essentially, I'm looking to drill down by department...so once the department is selected, that will narrow down the rejection type and machine number...but I don't know how to get past the 2nd level of data validation.
I've attached an example of the information I would be working with on a daily basis.
Bookmarks