|
发表于 2012-4-7 21:18
|
显示全部楼层
本楼为最佳答案
upczxf 发表于 2012-4-7 18:01
我想通过宏命令实现如下功能:
1、复制表格SHEET1,
2、在复制的SHEET1中,填充数据,具体规则是这样的。 ...
试试这个代码
直接运行 XieRu 过程即可!
- Dim TorF As Boolean, Hx As Long, Sh As Worksheet
- Sub CopyBiao()
- If Not TorF Then MsgBox "请运行 XirRu 程序!", , "错误": Exit Sub
- Sheets("Sheet1").Copy Sheets(Sheets.Count)
- Set Sh = Sheets(Sheets.Count - 1)
- Sh.Name = "施工记录" & Sheets.Count - 2
- Hx = 8
- End Sub
- Sub XieRu()
- Dim X As Long, Arr As Variant
- TorF = True
- With Sheets("数据")
- Hx = .Range("A65536").End(xlUp).Row
- Arr = .Range("A2:E" & Hx)
- End With
- Call CopyBiao
- For X = 1 To UBound(Arr)
- With Sh
- .Cells(Hx, "A") = Arr(X, 5)
- .Cells(Hx - 1, "C") = Arr(X, 2)
- .Cells(Hx - 1, "D") = Arr(X, 3)
- .Cells(Hx, "E") = Arr(X, 4)
- Hx = Hx + 2
- If X = UBound(Arr) Then .Range("C5") = Arr(X, 1): Exit For
- If Arr(X, 1) <> Arr(X + 1, 1) Then .Range("C5") = Arr(X, 1): Call CopyBiao
- End With
- Next
- End Sub
复制代码
|
|