Data validation trouble

[Bbongo8]

Hi

I have a workbook with 3 lists. the first choice restricts the size o
list 2, but I also want the first choice to restrict list 3. I canno
see how to link the 2 seperate lists (2&3), to the same (first) choice.

Can somebody help pleas

 

[James Ravenswood]

Hi

I have a workbook with 3 lists. the first choice restricts the size of
list 2, but I also want the first choice to restrict list 3. I cannot
see how to link the 2 seperate lists (2&3), to the same (first) choice.

Can somebody help please

See:

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