5,139
社区成员
发帖
与我相关
我的任务
分享
Public Sub GetScore()
Dim S1 As Worksheet, S2 As Worksheet
Dim b1 As Long, b2 As Long
Set S1 = Worksheets("表1")
Set S2 = Worksheets("表2")
For b1 = 4 To S1.Cells(65535, 2).End(xlUp).Row
For b2 = 4 To S2.Cells(65535, 2).End(xlUp).Row
If S1.Range("B" & b1) = S2.Range("B" & b2) And Sh1.Range("C" & b1) = Sh2.Range("A" & b2) Then
S1.Range("D" & b1) = S2.Range("C" & b2)
End If
Next b2
Next b1
End Sub
Public Sub GetScore()
With Worksheets("表1")
.Range("D4").Formula = "=VLOOKUP(B2,表2!B$2:C$" & Worksheets("表2").Cells(65535, 2).End(xlUp).Row & ",2,FALSE)"
.Range("D4:D" & .Cells(65535, 2).End(xlUp).Row).FillDown
End With
End Sub