I have the following in Excel

Row I K
6 Job_Family_desc NewGrade
7 TAL – Test1 8
8 TAL – Test1 8
9 TAL – Test1 8

For TAL you can only have a grade of 5 to 9
If someone enters 1 against NewGrade, that’s incorrect.

At the end of the process the uses clicks a macro button and then
Go to K7.
If I7 LIKE “TAL*” AND K7 IN (0,5,6,7,8,9) THEN Next
ELSE SET K7 = 0
IF I7 LIKE “BAL*” AND K7 IN (0,1,2,3,4,5,6,7,8,9) THEN Next
ELSE SET K7 = 0
IF I7 LIKE “SAL*” AND K7 IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14) THEN Next
ELSE SET K7 = 0
NEXT got to K8

Any help would be greatly appreciated

Debbie