Sub 按钮1_Click()
Application.ScreenUpdating = False
Dim i, k, v, arr, db
arr = Sheets("合同列表").Range("a1").CurrentRegion
Set db = CreateObject("Scripting.Dictionary")
For i = 2 To UBound(arr)
k = Trim(arr(i, 2))
v = arr(i, 4)
db(k) = v
Next i
Sheets("总表").Select
For i = 2 To Sheets("总表").UsedRange.Rows.Count
k = Trim(Cells(i, 3))
v = db(k)
Cells(i, 4) = v
Next i
Application.ScreenUpdating = True