Data validation trouble

[Bbongo8]

Hi,

I have attached a file with data validation lists. A2 restricts the list in C2, this choice restricts the list in E2.

I need the choice in C2 to also control a list of different choices in G2. The data for the list required in G2 is in the table A8:A27-AO8:AO27 - including headers.

Thanks

[dilipandey]

Hi,

I believe this is the same thread which I have just answered in following link:-

http://www.excelforum.com/excel-work...78#post2676678

Regards,
DILIPandey

<click on below 'star' if this helps>