|
楼主 |
发表于 2020-2-5 09:12
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Dim irows As Integer, i As Integer, k As Integer, sh As Worksheet, j As Integer
irows = Worksheets("明细").Range("a1").CurrentRegion.Rows.Count
For i = 2 To irows
'判断 i 这行的地区,对应的工作表是否存在
For j = 1 To Worksheets.Count
If Worksheets(j).Name = Worksheets("明细").Cells(i, 2).Value Then
'存在,就把数据拿过来
k = sh.UsedRange.Rows.Count
k = k + 1
sh.Range("a" & k).Resize(1, 6).Value = Worksheets("明细").Range("a" & i).Resize(1, 6).Value
GoTo 11
End If
Next j
'不存在,新建
Set sh = Worksheets.Add(after:=Worksheets(Worksheets.Count))
sh.Name = Worksheets("明细").Cells(i, 2).Value
sh.Range("a1").Resize(1, 6).Value = Worksheets("明细").Range("a1").Resize(1, 6).Value
k = sh.UsedRange.Rows.Count
k = k + 1
sh.Range("a" & k).Resize(1, 6).Value = Worksheets("明细").Range("a" & i).Resize(1, 6).Value
11:
Next i
End Sub
|
|