- Sub 生成工资条()
- Dim arr, r&, i&, k&
- Application.ScreenUpdating = False
- r = Range("a65536").End(3).Row
- If r > 7 Then Range("a8:r" & r).Delete
- aa = Range("c2")
- With Sheets(aa)
- r = .Range("a65536").End(3).Row
- arr = .Range("a6:r" & r)
- End With
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- If InStr(1, "岗位,部门", arr(i, 3)) = 0 Then
- m = m + 1
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- End If
- Next
- For i = 1 To UBound(brr)
- If Len(brr(i, 3)) Then
- k = (i - 1) * 3 + 5
- Else
- Exit For
- End If
- If i > 1 Then Cells(5, 1).Resize(3, 18).Copy Rows(k)
- Cells(k + 1, 1).Resize(1, UBound(brr, 2)) = Application.Index(brr, i, 0)
- Next
- Application.ScreenUpdating = True
- MsgBox "OK!", 64
- End Sub
复制代码 |