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