Change Data Validation List Based On Value In Cell

[jeff]

Cheers Aju

I attached workbook.In the workbook i now want the groups to go across the sheet instead of down the sheet.I have empty cells grouped where i will go across the sheet.They are 5 x 2 groups..i need help please altering the code in module 1.I can fix the sheet code

Thank you

JEFF

[jeff]

I got it to work
Thanks
Jeff

[Ingolf]

Jeff,

Selecting a leader in column B and in adjacent column appear members of that leader, then whay is needed validation for members? (in column C)

[jeff]

Ingolf

It allows me to use those names in any order or multiple times......

I have changed Reg`s name to Steve....it gives a error in code.....i can fix this error by changing the name in the Name Manager and sheet "Lists" which fixes the problem....is it possible to give a Messagebox warning saying the name needs changing in the Name Manager and sheet "Lists" instead of bringing up a error
Or maybe there is another solution
Regards

Jeff

[jeff]

bump