|
快乐的罗非鱼 发表于 2013-5-19 12:23
汇总表的格式就是把对应的内容提取出来 - Sub test()
- Dim sht As Worksheet, i As Integer
- Dim arr, brr, crr, drr
- For Each sht In Worksheets
- arr = Sheets("汇总表").Range("a1").CurrentRegion
- i = UBound(arr)
- If sht.Name <> "汇总表" Then
- With sht
- brr = sht.Range("b5:k7")
- crr = .Range("b9:k10")
- drr = .Range("b14:e14")
- End With
- With Sheets("汇总表")
- .Range("a" & i + 1).Resize(UBound(brr), UBound(brr, 2)) = brr
- .Range("i" & i + 1).Resize(UBound(crr), UBound(crr, 2)) = crr
- .Range("q" & i + 1).Resize(UBound(drr), UBound(drr, 2)) = drr
- End With
- End If
- Next
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|