Multiple Data Validation In One Range

[Lotus Cars]

Hi all,

I have a data table that I want to be able to have drop down's to pick up as a new datasheet is created.

My data table looks like this

Pay Grade	Pay Scale	Amount
Classroom Teacher	M1	10
Classroom Teacher	M2	15
Classroom Teacher	M3	20
Training & Learning	TLR1	2
Training & Learning	TLR2	6
Leadership Group	L1	50
Leadership Group	L2	64
Leadership Group	L3	75
Leadership Group	L4	90

<tbody>
</tbody>

So on my second tab, I've got a free entry column A for name, then in Column B I want to be able to pick the Pay grade, which I've used Data Validation for, not a problem. In column C I then want to pick the pay scale, but only see the applicable ones to the pay grade, ie if I've picked Leadership Group, I only want to see L1-L4, which I can't seem to work out.

Any help, as always, will be appreciated.

Cheers,

Lotus Cars

 

[marshy3300]

Ok, Is the data validation for pay grade a drop box on sheet2?

If if is, on sheet 1 add next to Amount column (D), =if(sheet2!$B$2=$A2,$B2,"").
Back on sheet2, add another data validation, list and reference column D

 

[Lotus Cars]

Thanks, so simple when you think about it.

I've been messing about with Comboboxes and all sorts, but that's just simple.

Cheers,

Ian