Displaying wrong result on SUMIFS due to space in left

I Have another

Sub CLEAR()
Dim cell As Range
For Each cell In Selection
cell.Value = Trim(cell.Value)
Next
End Sub

Can you let me know,what is the difference in this(taking a lot of time in large data) and above Post 10 (as you said) and which one is better that can do perfect match ?

The purpose of using above formula is to get the report in a separate sheet of Y column of SO & Y column of DO by matching :

SO sheet - A,B,V,AJ and get in one column of Y output (Gross qty)
DO sheet -A,T,V,X and get in another column of Y output (Gross qty)
And getting the differences in third column.For this I am using Pivot table after using above formula

Also suggest me if there is an alternative and best method.

Thanx again for your kind support.