- Sub test()
- Dim arr, brr, k%, i%, h%, str%
- arr = Sheet2.UsedRange
- brr = Range("a1").CurrentRegion
- For k = 1 To UBound(brr)
- h = Val(VBA.Mid(VBA.Left(brr(k, 1), InStr(brr(k, 1), "-") - 1), 2, 99))
- i = Cells(Rows.Count, "H").End(3).Row + 1
- Sheet2.Range("a" & h).Resize(1, 12).Copy Range("H" & i)
- Next
- End Sub
复制代码 |