Creating dependent data validation lists in multiple rows

Hi all,

How can i generate a data entry screen with dependent data validation (i.e. column wise) for multiple rows.

For example, in the sheet I have attached: Suppose an entry done in column C is "Bukoto", I want the drop down menu in column D to only show the possible centre numbers (i.e. 001 and 005 only). and when a given centre number is shown in column D, I want it to show the possible group numbers (i.e. 01, 02, 03, ..., 08 only); and when a group number is selected in column E, I want the dropdown menu in column F to show names of only those members that are in the selected area name, centre number, and group number.

See attachment for details. - The first column is where data entry will be done. And the second sheet shows the details of members from different areas, centre numbers and group numbers.

All help will be greatly appreciated.

Thanks,
R.

Here, see attached. In "Member - List" sheet multiple named ranges has been set up.

Headers contain name of each list. Note that Member List is set up only for Bukoto Group 01 as an example.
List.JPG
Data validation uses =Indirect($C2 & "CentreList") to dynamically look up which centre list to use based on area.
Similar set up are used in subsequent columns.

You'll find more detailed explanation in Contexture (I find it one of best resource for dependent drop down).
http://www.contextures.com/xlDataVal02.html

Originally Posted by CK76

Here, see attached. In "Member - List" sheet multiple named ranges has been set up.

Headers contain name of each list. Note that Member List is set up only for Bukoto Group 01 as an example.
Attachment 495825
Data validation uses =Indirect($C2 & "CentreList") to dynamically look up which centre list to use based on area.
Similar set up are used in subsequent columns.

You'll find more detailed explanation in Contexture (I find it one of best resource for dependent drop down).
http://www.contextures.com/xlDataVal02.html

Thanks a lot CK76. This is solved.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by Richard Buttrey

@Renildrah,

Our rules do not allow duplicate posts. This is a repeat of an earlier post. Please note our rules.

Hi Richard,

I actually did not mean to but I had earlier on posted it in the Excel general forum yet I wanted a solution from the Excel Functions/Formula forum. I forgot to withdraw it from the earlier forum but it will not happen again.

Thanks,
Joseph.

Originally Posted by Richard Buttrey

@Renildrah,

Our rules do not allow duplicate posts. This is a repeat of an earlier post. Please note our rules.

Hi Richard,

I actually did not mean to but I had earlier on posted it in the Excel general forum yet I wanted a solution from the Excel Functions/Formula forum. I forgot to withdraw it from the earlier forum but it will not happen again.

Thanks,
Joseph.

Originally Posted by Richard Buttrey

@Renildrah,

Our rules do not allow duplicate posts. This is a repeat of an earlier post. Please note our rules.

Hi Richard,

I actually did not mean to but I had earlier on posted it in the Excel general forum yet I wanted a solution from the Excel Functions/Formula forum. I forgot to withdraw it from the earlier forum but it will not happen again.

Thanks,
Joseph.