Help with Named Ranges used in Validation Lists

**BarbaraNie** · 10-09-2012, 09:15 AM

Hello, I am attempting to use the solution you've provided here in a workbook I've been tasked to build. The workbook (attached) has two sheets: "Tasks" and "Required_Activities".

•"Required_Activities" breaks down the process for getting a job done.
•"Element"
•"Subelements"
•"Activities"
•"TaskList"
•"Role" assigned to perform the task

In an effort to gather metrics, the "Tasks" sheet has a column for the user to select a "Role" (C2). I have the "Role" validation drop-down working, except the blanks are displayed. Ideally, based on the role selected, a validation list displays the "TaskList" (D2) for the Role (my second attempt at validation drop-down list not working). The Activity (E2) would be automatically populated based on the "Task". The Subelement (F2) would be automatically populated based on the Activity. The Element (G2) would be automatically populated based on the Subelement.

Any help and/or guidance would be greatly appreciated!

**K m** · 10-09-2012, 09:32 AM

To develop Dependant Data Validation Lists follow this link:

http://www.contextures.com/xlDataVal02.html

**ChemistB** · 10-09-2012, 10:04 AM

If your list has blanks in it, then your data validation will also. Best to use formulas to reassemble your lists on a hidden sheet without the blanks. I'm not sure what you want your dependent lists to look like. Do you want, for example, Purposetasks to be (based on rows 8 and 9 of Required_Activities) to be CCB meeting preparation, CCB post meeting database record updates and actions and Generate CCB meeting minutes? (without blanks again). You have a lot of merged cells which makes things more difficult to manipulate.