|
如何写一个代码,根据D列日期,判断月份,后自动复制到它对应月份表格,谢谢。
fangniuji 发表于 2012-1-17 14:35
速度满了点,谢谢!!!如果判断月份,后自动生出6月表格并把文件复制到它对应月份表格,这样更好,谢谢!! ...
- Sub test()
- Dim i&, j&, k&, s&, A(), B()
-
- With Sheets("整理")
- i = .Range("d3").End(xlDown).Row
- A = Range("a3:g" & i).Value
- End With
- ReDim B(1 To UBound(A), 1 To UBound(A, 2))
-
- For i = 1 To 12
- '满足条件,就加入数组b
- s = 0
- For j = 1 To UBound(A)
- If Month(A(j, 4)) = i Then
- s = s + 1
- For k = 1 To UBound(A, 2)
- B(s, k) = A(j, k)
- Next k
- End If
- Next j
-
- '导入第i个工作表中
- With Sheets(i & "月")
- .Range("a3:g65536").ClearContents
- If s > 0 Then
- .Range("a3").Resize(s, UBound(A, 2)) = B
- End If
- End With
- Next i
- End Sub
复制代码
|
|