View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_18_] Robert[_18_] is offline
external usenet poster
 
Posts: 1
Default Linking drop down lists

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