match data between two workbooks and show the matched and unmatched values

[abdo meghari]

hello
I have two workbooks stock and rp it should match between two files in COLS B,C,D,E about the values IN file rp should match with the last column and it's changeable every time I insert a new column in this case should match COL E in file stock with COL G in file rp then should bring all of data as in file target and show marks right and wrong and I put the result in file target
if this is not clear please inform

[Bo_Ry]

Please keep 3 files in the same folder and try

Please Login or Register  to view this content.

[abdo meghari]

thanks but when I add a new quantity like quantity 4 in file rp then it repeats copying the values in COL H may you see the file ,please

[Bo_Ry]

Try add this line

Please Login or Register  to view this content.

[abdo meghari]

that's a great just I would last thing I would add two columns show the positive and negative values after subtracting I put some comment inside the file I appreciate if mod the code
thanks again

[Bo_Ry]

Try

Please Login or Register  to view this content.

[abdo meghari]

awesome ! many thanks buddy for this a great assistance