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

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Pay Grade[/TD]
[TD]Pay Scale[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Classroom Teacher[/TD]
[TD]M1[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Classroom Teacher[/TD]
[TD]M2[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Classroom Teacher[/TD]
[TD]M3[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Training & Learning[/TD]
[TD]TLR1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Training & Learning[/TD]
[TD]TLR2[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Leadership Group[/TD]
[TD]L1[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Leadership Group[/TD]
[TD]L2[/TD]
[TD]64[/TD]
[/TR]
[TR]
[TD]Leadership Group[/TD]
[TD]L3[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]Leadership Group[/TD]
[TD]L4[/TD]
[TD]90[/TD]
[/TR]
</tbody>[/TABLE]


















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