Linking drop down lists

R

Robert

Hi - can anyone help a novice with this problem please?

I have a worksheet with a column called 'staff group' which I have set up as a drop down list using the validation item on the data menu.

The next column is grade and I want the user to be presented with a different drop down list of choices for 'grade' depending on the choice they made for 'staff group'

Is this possible? If so is it complex as I am a real beginner. Can anyone give me some pointers please?

Regards

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
drop down list 1
Pick from drop-down list gives empty or erroneous result 6
Filtered drop down list 2
Move Drop Down List to the Top of the Cell 0
Using Drop Down list to an If Statement to another Drop Down list 3

Top