|
发表于 2017-7-3 16:59
|
显示全部楼层
本楼为最佳答案
本帖最后由 chart888 于 2017-7-3 17:01 编辑
- Sub test()
- Dim Sh As Worksheet
- Dim i&, x&, r&, d
- Set d = CreateObject("Scripting.Dictionary")
- For Each Sh In ThisWorkbook.Worksheets
- d(Sh.Name) = ""
- Next
- arr = [A1].CurrentRegion
- For i = 2 To UBound(arr)
- x = Left(arr(i, 2), 2)
- For Each Sh In Worksheets
- If Not d.exists(x) Then
- ThisWorkbook.Worksheets.Add after:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
- ActiveSheet.Name = x
- d(x) = ""
- r = Cells(1, 1).CurrentRegion.Rows.Count + 1
- Cells(r, 1) = arr(i, 1): Cells(r, 2) = arr(i, 2)
- Else
- Worksheets(x).Activate
- r = Cells(1, 1).CurrentRegion.Rows.Count + 1
- Cells(r, 1) = arr(i, 1): Cells(r, 2) = arr(i, 2)
- End If
- Next
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|