Drop Down Box - Formuale Required

midfieldgeneral11

Active Member
Joined
Feb 11, 2004
Messages
460
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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top