Find difference between numbers in cells in 2 columns

HI I would like to have a macro, which can find the difference in Sheet "Final Match" between Cell values in column I and column J. So if there is a difference between I3 and J3 It display the result in K3. And like that all the way down. All controlled with a command button from sheet1
Please have a look at my test sheet.
Sincerely
Abjac

Hi Abjac,
I think this is a continuation of your previous topic. If so, then try

Please Login or Register  to view this content.

HI Nilem. Your right. Thats what it is. Infact it should be a little problem, but i found out of not so easy. The macroes i found gave wrong result or they did not count after the comma. Your code is working great together with the other for sure. I have a little request for a change. First i would like to remove the zeroes in the fields which dont have a difference and then also not to display a minus, if there is a minus.
But your code according to the other if great thanks.
'
Jindon you code according to this testsheet i uploaded, show the wrong result. I have infact here only one error i think in row 179. the difference is
1,23 but your code gives the result of -123000000000002. So this is not correct off course.
Will wait to make this solved untill you have had a look.

Thanks for now to both

SIncerely
Abjac

Swap 1 and 2 in the formula

Please Login or Register  to view this content.

see attachment

HI Jindon. It changed but only removed the minus in front. The result should be 1,23 but it display this 123000000000002.
So its not quite dorrect. Nilem dont know whats wrong, but i cant download the file right now. Will try later on if its better

Thanks

Abjac

Something is wrong
change to

Please Login or Register  to view this content.

HI Nilem dont know whats wrong could you try to upload it again. I can download my own file but not yours.

Sincerely
Abjac

Abjac,
this is the file from your previous topic. I just joined a macro for columns 'New Cars Input' and 'Difference'
If you have trouble downloading a file from the forum, write to me PM and I will send the file to your email.