I am trying to find the absolute difference between the value in Cell C3 in Sheet2 and the values in Col C in Sheet1. After which, the differences are sorted in Descending order. The differences calculated will be inputted into column D. I have put everything in the change event which is triggered whenever column C is changed. This is the code thus far, there are no errors being thrown up but the absolute differences are also not showing in column D in Sheet1. Can anyone help me to see what's wrong here? Any help is greatly appreciated!!
Bookmarks