|I would like the following to happen:|
User chooses a category in Column A.
Based on category, the settings (Columns B - E) populate with category-specific options or grey out if there are no options.
Choose Category A = all four settings populate with default settings (setting 1 = CAS1O1, setting 2 = CAS2O1, setting 3 = CAS3O1, setting 4 = CAS4O1), but the user can edit using options lists (lists named: CatASetting1, CatASetting2, CatASetting3, CatASetting4).
Choose Category B = Settings 1 and 2 populate with default settings and lists: CatBSetting1, CatBSetting2. other settings grey out and lock
Choose Category C = Settings 1 and 2 grey out and lock. Settings 2 and 3 populate with default settings and lists: CatCSetting3, CatCSetting4
I defined the lists on the "validations" sheet using the name manager.
I have an example file, but I don't see how to attach files here.