Creating a 3-Tiered Dynamic Drop-Down List within a Table

[Kogen]

Hello Everyone,

I've been searching for an answer to an issue I can't seen to wrap my head around. It involves a 3-tiered dynamic drop down list within an entry table. The intended use for the sheet is usability for more than one person, so I need to use drop-down list functionality for each cell per table row. I've recently tried using =Unique to pull a spill list in an attempt to reference lookups, but I just don't know how to get this to work for each new row within an entry table. Because I have to keep the endusers in-mind, This needs to stay dynamic all the way around. Could someone please help?

[AliGW]

How does this thread differ from this on: https://www.excelforum.com/excel-pro...ml#post5437486 ?

[Kogen]

When I posted it, I was unaware of macro restrictions from my organization. Do I need to close/delete that thread?

[AliGW]

Administrative Note:

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...t-not-vba.html