Hello,
I am trying to come up with a way to sum the total of non matching cells when comparing two columns in two workbooks. So far I have the following, but I am bit confused as to what to do next:
strRangeToCheck = "F2:F10000"
x = Worksheets("Contract").Range(strRangeToCheck)
y = Worksheets("As Built").Range(strRangeToCheck)
'Loop through and do a comparison to add up the cells that aren't identical
For iRow = LBound(x, 1) To UBound(x, 1)
For icol = LBound(x, 2) To UBound(x, 2)
If x(iRow, icol) = y(iRow, icol) Then
'cells are identical.
'do nothing
Else: For iRow = LBound(x, 1) To UBound(x, 1)
For icol = LBound(x, 2) To UBound(x, 2)
If x(iRow, icol) <> y(iRow, icol) Then
Range("A8") =
With Range"A8" being the resultant cell.
Bookmarks