Dynamic Display of List Values Based Upon Value Selected From Another List

kman

New Member
Joined
Dec 11, 2002
Messages
35
I have successfully created several drop down lists however I am trying to display different drop down values based upon a selection.

Ex. In cell A3 it displays a drop down list with the values Keyword, Certification, Skills

If a user selects Keyword from cell A3 I want them to be able to specify only values from the Keyword List which I've already created

If a user selects Certification from cell A3 I want them to be able to specify only values from the Certification List which I've already created

If a user selects Skills from cell A3 I want them to be able to specify only values from the Skills List which I've already created
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,112,998
Messages
5,543,194
Members
410,585
Latest member
MaintenanceReportGuy
Top