Hi Team,
I want to compare two excels ,if the row values are same in two excels pick the value from related row(Count value) from excel 1 and paste in second excel(Value calculated)
Example as below:
Excel 1:
Count Code
6677 B522
69 RPCB
1 T642
0 T656
2 T679
Excel 2:
Code Value calculated(Expected)
B522 6677
b549 0
B715 0
T679 2
Appreciate your help!