本帖最后由 hasyh2008 于 2022-6-16 19:11 编辑
Sub tt()
On Error Resume Next
Dim K%, X%, Str$
Dim Arr, Ar, Cr()
Dim D
Set D = CreateObject("scripting.dictionary")
For K = 1 To 2
Arr = Sheets(K).Range("A1").CurrentRegion
For X = 1 To UBound(Arr)
Str = Arr(X, 1) & "-" & Arr(X, 2)
If Arr(X, 3) > D(Str) Then D(Str) = Arr(X, 3)
Next X
Next K
Ar = Application.Transpose(Array(D.keys, D.items))
ReDim Cr(1 To UBound(Ar), 1 To 3)
For X = 1 To UBound(Ar)
Cr(X, 1) = Split(Ar(X, 1), "-")(0)
Cr(X, 2) = Split(Ar(X, 1), "-")(1)
Cr(X, 3) = Ar(X, 2)
Next X
With Sheet2
.Cells(1, 1).Resize(UBound(Ar), 3) = Cr
End With
End Sub