|
紅色處為【明細表】的檔案路徑,再修改一下
Sub demo()
Set d = CreateObject("Scripting.Dictionary")
With GetObject("c:\qq\data.xlsx")
For Each Sheet In .Sheets
a = Sheet.[a1].CurrentRegion
For i = 4 To UBound(a)
If Not d.exists(a(i, 2)) Then: d(a(i, 2)) = a(i, 11)
Next
Next
.Close
End With
a = [a1].CurrentRegion
For i = 2 To UBound(a)
a(i, 6) = d(a(i, 3))
Next
[a1].CurrentRegion = a
End Sub
祝順心,南無阿彌陀佛!
|
|