Drop Down Box - Formuale Required

[midfieldgeneral11]

Good Morning

Can you help me.

I have a drop down box in Column A which has 5 options.

e.g.

Sam
John
Simon
Andy
Sue

Column B is another drop down box but I only want to show a list which are related to the option select in Column A

So column B drop down would be FULL list

Sam – London
Sam – Romford
Sam – Chatham

John – London
John – Romford
John – Chatham


Simon – London
Simon – Romford
Simon – Chatham


Andy – London
Andy – Romford
Andy– Chatham

Sue – London
Sue – Romford
Sue – Chatham

So if Sam is selected in Column A I only want to see Sam’s 3 items appear.

Can you help?

Simon

 

[VoG]

See if this helps http://www.contextures.com/xlDataVal02.html