I have an error on doing the sumproduct function on the vba.
It should be sheet1(cont no) = sheet2(cont no) & sheet1(amount) = sheet2(amount)
then copy the sheet2 info into sheet3.
But why it will copy all info into sheet3 below is my coding.
Sheet 1
no Cont no amount
a 111 10
b 333 10
c 222 20
d 444 20
e 555 20
f 222 10
Sheet 2
no Cont no amount
a 111 20
b 333 20
c 333 10
d 444 20
e 555 20
f 222 10
sheet 3
no Cont no amount
a 111 20
b 333 20
![]()
Please Login or Register to view this content.
Bookmarks