Macro for determining differences within same spreadsheet

[KMJM2019]

I'd like to create a macro that quickly identifies 2 datasets in the same spreadsheet and highlights any differences. I need to reconcile from a different system, so I export that data into my existing spreadsheet. They need to match exactly. I have used conditional formatting successfully, but that's not what the managers want. They want a one click macro that does the reconciling for them. I know it's ridiculous since conditional formatting will work, but some people are intimidated by having to type in a formula. Thank you!!!

 

[oldbrewer]

a

b

c

d

a

b

c

d

e

f

g

h

e

z

g

h

I

j

k

l

I

j

x

l

f and q have been colored yellow by the macro

Sub Macro4()

'

' Macro4 Macro

' Macro recorded 30/01/2019 by bob

'

'

For j = 1 To 3

For k = 1 To 4

If Cells(j, k) <> Cells(j, k + 10) Then GoTo 100 Else GoTo 200

100 Cells(j, k).Select

With Selection.Interior

.ColorIndex = 6

.Pattern = xlSolid

End With

200 Next k

Next j

End Sub

<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

a

b

c

d

a

b

c

d

e

f

g

h

e

z

g

h

I

j

k

l

I

j

x

l

f and K have been colored yellow by the macro

Sub Macro4()

'

' Macro4 Macro

' Macro recorded 30/01/2019 by bob

'

'

For j = 1 To 3

For k = 1 To 4

If Cells(j, k) <> Cells(j, k + 10) Then GoTo 100 Else GoTo 200

100 Cells(j, k).Select

With Selection.Interior

.ColorIndex = 6

.Pattern = xlSolid

End With

200 Next k

Next j

End Sub

<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>
</tbody>