Hi again

I have testet the macro again, and on my test sheets it's working as you
require.

Maybe column N should be cleared at the beginning at the macro.

To do this add this line after set sh2=....

sh2.range("N3:N65536").clearcontents

Hopes it helps.

Best regards,
Per

"Hannes" skrev i meddelelsen
...
Hi Per,

you were right about the module name ;-) The macro runs BUT: currently
just
the values of column A have to match in both sheets in a row for the delta
calculation. So if the values of column C and D mismatch the macro
calculates
the delta anyway.
I need the macro just to calculate the delta if all values in columns (A,
C,
D) match between the two sheets. The values of column A, C, D in a row
should
serve as identifier. So if even only one value differs the macro should
consider a mismatch and go to the next row.

Many thanks!!

Regards,
Hannes