abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hi, everyone i would code to show difference values between columns into two sheets and show the result in another sheet for more explanation
sheet1:
<tbody>
</tbody>
sheet2:
<tbody>
</tbody>
what i would the result in sheet3:
<tbody>
</tbody>
sheet1:
ITEM | BRAND | TYPE | ORIGIN | QUNTITY |
1 | 10.00-16 8PR | FSM | THI | 7 |
2 | 10-18 10PR FG | FG | *** | 10 |
3 | 10-16.5 8PR | FG | INDO | 20 |
<tbody>
</tbody>
sheet2:
ITEM | BRAND | TYPE | ORIGIN | QUNTITY |
1 | 10.00-16 8PR | FSM | THI | 7 |
2 | 10-18 10PR FG | FG | *** | 10 |
<tbody>
</tbody>
what i would the result in sheet3:
ITEM | BRAND | TYPE | ORIGIN | QUNTITY |
1 | 10.00-16 8PR | FSM | THI | 0 |
2 | 10-18 10PR FG | FG | *** | 0 |
3 | 10-16.5 8PR | FG | INDO | 20 |
<tbody>
</tbody>
Last edited: