I have sheet1 contains items for column B and sheet2 contains items from column B: D if the values for sheet2 in columns E,F are not the same thing or one of them is wrong with comparison columns C,D for sheet1 then should copy and put next to similar cell also subtract column K from l and show in column M after subtract column C FROM k and D from I and if the same things in values then should show hyphen . also if there is new item in sheet1 but is not existed in sheet2 then should highlight by red in column B for sheet1 .
the result from column G:M in sheet1.
the result from column G:M in sheet1.
| (6).xlsx | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | ITEM | ID | MONTH1 | MONTH2 | ITEM | ID | TTR | MTR | MONTH1 | MONTH2 | BALANCE | ||||
| 2 | 1 | MT ASGL-VEN SD-1 | 12 | 10 | 1 | - | - | - | - | - | - | ||||
| 3 | 2 | C-ZER MN/100 TR12 | 130 | 0 | 2 | - | - | - | - | - | - | ||||
| 4 | 3 | BB 2000MN TT GH | 90 | 0 | 3 | - | - | - | - | - | - | ||||
| 5 | 4 | TRM 2000MN TT GH | 0 | 16 | 4 | - | - | - | - | - | - | ||||
| 6 | 5 | BD 234 NH GG | 80 | 90 | 5 | BD | 234 NH | GG | 2 | 20 | -18 | ||||
| 7 | 6 | BR 111/33M ER HJ | 70 | 90 | 6 | BR | 111/33M | R HJ | 4 | 10 | -6 | ||||
| 8 | 8 | VB 145** SS TF HJK | 0 | 45 | 7 | - | - | - | - | - | - | ||||
| 9 | 9 | DEWR 1222** SS TF HJK | 34 | 30 | 8 | DEWR | 1222** | SS TF HJK | 0 | 5 | -5 | ||||
| 10 | 11 | DAS 1223** SS TF HJK | 0 | 36 | |||||||||||
sheet1 | |||||||||||||||
