本帖最后由 一指禅62 于 2017-4-11 09:34 编辑
Sub lsc()
Dim brr(1 To 10000, 1 To 14)
arr = Sheet1.Range("a1:ap" & Sheet1.Cells(Rows.Count, 1).End(3).Row)
For i = 2 To UBound(arr)
If Format(arr(i, 5), "yyyymm") = Format(DateAdd("m", -1, Range("M2")), "yyyymm") Then
k = k + 1
brr(k, 1) = k : brr(k, 2) = arr(i, 2): brr(k, 3) = arr(i, 3): brr(k, 4) = arr(i, 4)
brr(k, 5) = arr(i, 5): brr(k, 6) = arr(i, 16): brr(k, 7) = arr(i, 17): brr(k, 8) = arr(i, 18)
brr(k, 9) = arr(i, 19): brr(k, 10) = arr(i, 20): brr(k, 11) = arr(i, 21): brr(k, 12) = arr(i, 37)
brr(k, 13) = arr(i, 38): brr(k, 14) = arr(i, 39)
End If
Next
With ActiveSheet
.[a15:n1000].Clear
.Columns("m").NumberFormatLocal = "@"
.[a15].Resize(k, 14) = brr
End With
End Sub
|