|
本帖最后由 hzruziniu 于 2020-1-10 16:31 编辑
TEST.rar
(27.7 KB, 下载次数: 12)
- <div class="blockcode"><blockquote>Sub 生成() '
- Application.ScreenUpdating = False
- arr = Sheets("资料表").[a1].CurrentRegion
- Sheets("生成").Select
- For i = 2 To UBound(arr)
- n = (i - 2) * 12 + 1
- If n > 12 Then
- Sheets("模板").Range("A1").CurrentRegion.Copy Sheets("生成").Range("a" & n)
- Rows("1:12").Copy
- Rows(n + 1 & ":" & n + 12).PasteSpecial (xlPasteFormats) 'xlPasteColumnWidths
- End If
- Range("c" & n) = arr(i, 3)
- Range("c" & n + 1) = arr(i, 6)
- Range("c" & n + 2) = arr(i, 5)
- Range("c" & n + 3) = arr(i, 9)
- Range("c" & n + 4) = arr(i, 14)
- Range("c" & n + 5) = arr(i, 4)
- Range("c" & n + 6) = arr(i, 3)
- Range("c" & n + 7) = arr(i, 6)
- Range("c" & n + 8) = arr(i, 5)
- Range("c" & n + 9) = arr(i, 9)
- Range("c" & n + 10) = arr(i, 14)
- Range("c" & n + 11) = arr(i, 4)
-
- Range("e" & n) = arr(i, 5)
- Range("e" & n + 1) = arr(i, 7)
- Range("e" & n + 2) = arr(i, 8)
- Range("e" & n + 3) = arr(i, 10)
- Range("e" & n + 6) = arr(i, 5)
- Range("e" & n + 7) = arr(i, 7)
- Range("e" & n + 8) = arr(i, 8)
- Range("e" & n + 9) = arr(i, 10)
- Next
- Application.ScreenUpdating = True
- End Sub
- Sub 删除() '删除12行以下的全部数据行
- Sheets("生成").Rows("13:" & Rows.Count).Clear
- End Sub
复制代码
注意:在生成表保留12行的一张原表。 |
评分
-
1
查看全部评分
-
|