|
参与一下。。。
- Sub ykcbf() '//2024.4.28
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- Set sh = ThisWorkbook.Sheets("数据源")
- With sh
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .Range("A1:aa" & r)
- End With
- u = UBound(arr, 2)
- On Error Resume Next
- For i = 1 To r
- If InStr(arr(i, 1), "#page") Then
- n = n + 1
- d1(n) = i
- End If
- Next
- ReDim brr(1 To UBound(arr), 1 To 2)
- For k = 1 To d1.Count
- r1 = d1(k)
- If k = d1.Count Then r2 = r Else r2 = d1(k + 1) - 1
- For i = r1 + 6 To r2
- If arr(i, 1) <> Empty Then
- If InStr(arr(i, 1), "Table") = 0 Then
- For j = 2 To UBound(arr, 2)
- s = Trim(arr(r1 + 2, 1)) & "|" & Trim(arr(i, 1)) & "|" & Trim(arr(r1 + 5, j))
- d(s) = arr(i, j)
- Next
- End If
- End If
- Next
- Next
- On Error Resume Next
- For Each sht In Sheets
- If sht.Name <> sh.Name Then
- With sht
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 3)
- For i = 5 To UBound(arr)
- If arr(i, 1) <> Empty Then
- If InStr(arr(i, 1), "*") Then
- lr = i
- i = i + 1
- End If
- For j = 2 To UBound(arr, 2)
- s = Trim(arr(lr, 1)) & "|" & Trim(arr(i, 1)) & "|" & Trim(arr(lr, j))
- If d.exists(s) Then
- arr(i, j) = d(s)
- End If
- Next
-
- End If
- Next
- .[a1].Resize(r, 3) = arr
- End With
- End If
- Next
- Set d = Nothing
- Set d1 = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|