Tabs or skip over cells with certain input entered

[jr_x88]

Hi there.



[TABLE="class: grid, width: 0"]
<tbody>[TR]
[TD]GRADE[/TD]
[TD]/[/TD]
[TD]LEVEL[/TD]
[TD]/[/TD]
[TD]XXHRS[/TD]
[TD]/[/TD]
[TD]FF/RU HRS[/TD]
[TD]/[/TD]
[TD]-
[/TD]
[/TR]
[TR]
[TD]XX[/TD]
[TD]/[/TD]
[TD]X[/TD]
[TD]/[/TD]
[TD]4[/TD]
[TD]/[/TD]
[TD]-[/TD]
[TD]/[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]RU[/TD]
[TD]/[/TD]
[TD]X[/TD]
[TD]/[/TD]
[TD]-[/TD]
[TD]/[/TD]
[TD]4[/TD]
[TD]/[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]




I have 3 columns. column "GRADE" is a "DATA VALIDATION" containing inputs XX,RU,FF.





I wish to tab or enter over the cell that needs no input (-) when the certain input in column "GRADE" are entered

leaving the auto filled "-" in the skipped cell..hopefully protecting it if I can.



This is a basic example of what I need to do as the are different levels but this doesnt change hrs formatting.





Please help thanks chris


......................................................................................

 

[oldbrewer]

[TABLE="width: 664"]
<colgroup><col span="3"><col><col span="6"></colgroup><tbody>[TR]
[TD]GRADE[/TD]
[TD]LEVEL[/TD]
[TD]XXHRS[/TD]
[TD]FF/RU HRS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XX[/TD]
[TD]X[/TD]
[TD][/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RU[/TD]
[TD]X[/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD]X[/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD]X[/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RU[/TD]
[TD]X[/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XX[/TD]
[TD]X[/TD]
[TD][/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XX[/TD]
[TD]X[/TD]
[TD][/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RU[/TD]
[TD]X[/TD]
[TD]SKIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]I used a formula to put skip in the cells[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]where no input is required so you need to overtype the formula[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]in the blank cells[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]