|
- Sub Lianxi2()
- Dim x As Long, y As Long, m As Long, k As Long
- Dim max_x As Long
- Dim arr, brr()
- max_x = ActiveSheet.Range("a65536").End(xlUp).Row
- arr = ActiveSheet.Range("a1").Resize(max_x, 3)
- For x = 2 To max_x
- If arr(x, 3) > 1 Then
- For y = 1 To arr(x, 3)
- k = k + 1
- ReDim Preserve brr(1 To 3, 1 To m + k)
- brr(1, m + k) = arr(x, 1)
- brr(2, m + k) = brr(1, m + k) + k - 1
- brr(3, m + k) = arr(x, 2) / arr(x, 3)
- Next
- m = m + k
- k = 0
- Else
- m = m + 1
- brr(1, m) = arr(x, 1)
- brr(2, m) = arr(x, 1)
- brr(3, m) = arr(x, 3)
- End If
- Next
- With ActiveSheet.[j1]
- .Offset(0, 0) = "预定日期"
- .Offset(0, 1) = "使用日期"
- .Offset(0, 2) = "金额"
- .Offset(1).Resize(m, 3) = Application.Transpose(brr)
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|