Hi all
I need help to take value of Cell that:
with j = 2 to lastrow
if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R101" then copy value in Cell(i;C) to Hj
if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R102" then copy value in Cell(i;C) to Ij
if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R103" then copy value in Cell(i;C) to Jj
This mean I want after run code, the result is:
H2 = 0, I2 = 0, J2 = 0
H3 = 5000, I3 = 6000, J3 = 7000
H4 = 10, I4 = 5, J4 = 20
..........
thanks./.
<tbody>
</tbody>
I need help to take value of Cell that:
with j = 2 to lastrow
if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R101" then copy value in Cell(i;C) to Hj
if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R102" then copy value in Cell(i;C) to Ij
if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R103" then copy value in Cell(i;C) to Jj
This mean I want after run code, the result is:
H2 = 0, I2 = 0, J2 = 0
H3 = 5000, I3 = 6000, J3 = 7000
H4 = 10, I4 = 5, J4 = 20
..........
thanks./.
A | B | C | D | E | F | G | H | I | J |
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) |
xxxx | R101 | 100 | zzz | ||||||
xxxx | R102 | 200 | zzzz | ||||||
xxxx | R103 | 500 | yyyy | ||||||
yyyy | R101 | 10 | xxxx | ||||||
yyyy | R102 | 5 | ..... | ||||||
yyyy | R103 | 20 | |||||||
zzzz | R101 | 5000 | |||||||
zzzz | R102 | 6000 | |||||||
zzzz | R103 | 7000 | |||||||
..... | ..... | .... |
<tbody>
</tbody>