Four cascading data validation lists that can be used on multiple rows

I've been struggling for days playing with different potential solutions for this. On my first sheet I'm trying to display data that is organized by the four data validation lists. The data set the validation lists are based on is on the second sheet. The data set on the second sheet contains exclusively names (first/last, and locations). It's regional data so the first data validation is easy - I use a unique function to provide that data - but I need it to filter the second list, the second list to filter the third, and the third to filter the fourth - I need to be able to do this within each row on the first sheet. Here is an example:

I've found that Kutools is able to do this but as soon as someone else without Kutools opens it - it breaks. Any help would be appreciated.

Often in Kutools they offer a MS Excel/formula based way to accomplish the same.

I'm not sure if there is some coding that Kutools puts in the background that goes away when it's not present but when I sent the file to a colleague that did not have Kutools the dropdown and formulas were there but none of them worked. When I tried to edit the formula on a separate machine it gave me the "the source currently evaluates to an error" - something Kutools does bypasses this...

thank you for the response

I seem to be having trouble with it. The drop downs are acting like buttons? I'd like to better understand what you mean by structured tables and the sheet code module - and understand what I'm looking at when I open the file. Any chance there's a quick way to explain it?

Hello! I am learning as well and worked on a project similar to this one recently.

You will see duplicate names in the drop-down lists if the name appears more than once in a column. I hope this helps!

CascadeDataValExample - Data Validation Formulas.jpg

That certainly does. Any way to insert unique in there so the final list does not have duplicates? I'm going through each piece of the formula but it's not clear to me where I might be able to stick a unique modifyer

I've been trying to figure that out as well! I created unique lists of names from your original data but the OFFSET formula isn't displaying the full unique list in my result. So sorry I couldn't assist more. If I figure it out, I'll let you know.

When I opened your file the drop downs acted more like inserted shapes and didn't actually "dropdown" for me.

I'm attaching the workbook I worked on (your original data plus my own). That way you can play around with it.

This is my first attempt at attaching an Excel file... I hope this works. LOL

PC and using Office 365 locally - might be 64 bit? But it did not ask me to enable macros

Thank you. That one worked.

Problem is it asks if you want to proceed everytime you click the dropdown and if you say yes it erases what was in there. Thank you for that suggestion though.