|
代码供参考。。。- Sub ykcbf() '//2024.2.16
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set d = CreateObject("Scripting.Dictionary")
- p = ThisWorkbook.Path
- f = p & "\总单放在E盘\总单.xls" '//文件路径按实际改一下
- wbmm = "123": shtmm = "456"
- Set ws = ThisWorkbook
- Set sh = ws.Sheets("Sheet1")
- With sh
- .Unprotect Password:=shtmm
- r = .Cells(Rows.Count, "x").End(3).Row
- arr = .Range("x1:aa" & r)
- For i = 2 To UBound(arr)
- s = arr(i, 1)
- If arr(i, 2) <> Empty Then
- If Not d.exists(s) Then
- d(s) = .Cells(i, "y").Resize(1, 3)
- End If
- End If
- Next
- .Protect Password:=shtmm
- End With
- On Error Resume Next
- Set wb = Workbooks.Open(f, 0, False, , wbmm, wbmm)
- With wb.Sheets("Sheet2")
- r = .Cells(Rows.Count, 1).End(3).Row
- For i = 4 To UBound(arr) Step 3
- c = .Cells(i, Columns.Count).End(xlToLeft).Column
- s = .Cells(i, 2)
- If d.exists(s) Then
- If .Cells(i, c) <> d(s)(1, 1) Then
- c = c + 1
- t = d(s)
- For x = 1 To 3
- .Cells(i + x - 1, c) = d(s)(1, x)
- Next
- End If
- End If
- Next
- End With
- wb.Close 1
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|