Hi all
I have file data.xlsm with 03 sheets("result","balance01","balance02")
Now I want macro VBA to check value each account number in row i sheet(balance01).column(B,C) with the same account number in row j sheets(balance02).column(F,G)
If the same account but value(Bi) <> value (Fj) or value(Ci) <> value (Gj) => copy row have diffrience value to sheets(result)
Please help me to do this
sheets(balance01) like this:
<tbody>
</tbody>
sheets(balance02) like this:
<tbody>
</tbody>
sheets(result) like this:
<tbody>
</tbody>
I have file data.xlsm with 03 sheets("result","balance01","balance02")
Now I want macro VBA to check value each account number in row i sheet(balance01).column(B,C) with the same account number in row j sheets(balance02).column(F,G)
If the same account but value(Bi) <> value (Fj) or value(Ci) <> value (Gj) => copy row have diffrience value to sheets(result)
Please help me to do this
sheets(balance01) like this:
A | B | C | D | E | F | G | H | |
1 | Acc number | Debit | Credit | Increase | Decrese | Debit | Credit | |
2 | 10101 | 1000 | 100 | |||||
3 | 10102 | 2000 | 200 | |||||
4 | 10103 | 3000 | 300 | |||||
5 | 10104 | 3000 | 300 | |||||
6 |
<tbody>
</tbody>
sheets(balance02) like this:
A | V | C | D | E | F | G | H | ||
1 | Acc number | Debit | Credit | Increase | Decrese | Debit | Credit | ||
2 | 10101 | 1000 | 101 | ||||||
3 | 10102 | 2000 | 200 | ||||||
4 | 10103 | 3000 | 300 | ||||||
5 | 10104 | 3001 | 300 | ||||||
6 | |||||||||
7 | ... |
<tbody>
</tbody>
sheets(result) like this:
A | B | C | D | E | F | G | H | |
1 | Acc number | Debit balance01 | Creadit balance01 | Debit balance 02 | Credit balance02 | |||
2 | 10101 | 1000 | 100 | 1000 | 101 | |||
3 | 10104 | 3000 | 300 | 3001 | 300 | |||
4 |
<tbody>
</tbody>