Sub demo()
Set d = CreateObject("Scripting.Dictionary")
a = Sheets("班表").UsedRange
For j = 3 To UBound(a, 2)
Key = Format(a(1, j), "M月d日班表")
Set d(Key) = CreateObject("Scripting.Dictionary")
For i = 2 To UBound(a)
If a(i, j) > 0 Then d(Key)(a(i, j) & "") = i
Next
Next
With Sheets(2)
b = .UsedRange
For i = 1 To UBound(b)
v = Replace(b(i, 1), "A", "")
r = d(.Name)(v)
If r Then
b(i, 5) = a(r, 1)
b(i, 6) = a(r, 2)
End If
Next
.[a1].Resize(UBound(b), UBound(b, 2)) = b
End With
End Sub
祝順心,南無阿彌陀佛!