|
- Sub test()
- Application.ScreenUpdating = False
- Set dic = CreateObject("scripting.dictionary")
- ar = Sheet1.Range("A1").CurrentRegion.Resize(, 1).Offset(, 1)
- For i = 2 To UBound(ar)
- tmp = Split(" " & Replace(ar(i, 1), Chr(10), " "))
- For j = 1 To UBound(tmp)
- dic(tmp(j)) = Replace("C2:D2,F2", "2", i)
- Next
- Next
- ar = Sheet2.Range("A1").CurrentRegion.Resize(, 1)
- Sheet2.Range("A1").CurrentRegion.Offset(1, 1).Delete
- For i = 2 To UBound(ar)
- s = dic(CStr(ar(i, 1)))
- If Len(s) Then Sheet1.Range(s).Copy Sheet2.Cells(i, 2)
- Next
- Sheet2.Range("A1").CurrentRegion.Borders.LineStyle = 1
- End Sub
复制代码 |
|