|
Sub test()
Dim A, d, i%, j%, k, t, r&
A = Sheets(1).Range("a1").CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To Sheets.Count
d(Sheets(i).Name) = i
Next i
k = d.keys: t = d.items
For i = 2 To UBound(A)
For j = 0 To UBound(k)
'如果数据的名称含工作表名
If InStr(A(i, 2), k(j)) Then
With Sheets(t(j))
'如果该表里找不到代号a(i,1)
If .Range("a:a").Find(A(i, 1)) Is Nothing Then
r = .Range("a65536").End(xlUp).Row + 1
.Cells(r, 1) = A(i, 1)
.Cells(r, 2) = A(i, 2)
End If
End With
Exit For
End If
Next j
Next i
End Sub
3.rar
(20.49 KB, 下载次数: 9)
|
|