|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub TEST()
Application.ScreenUpdating = False '关闭屏幕刷新
Application.DisplayAlerts = False '关闭系统提示
Dim arr, n As Long
Sheets("固定格式").Range("A11:I46").ClearContents
n = Sheets("明细表").Range("A65533").End(xlUp).Row
arr = Sheets("明细表").Range("A2:K" & n).Value
K = 11
For i = 1 To UBound(arr)
If arr(i, 6) = Sheets("固定格式").Range("C3").Value Then
Sheets("固定格式").Cells(K, "A") = arr(i, 1)
Sheets("固定格式").Cells(K, "B") = arr(i, 2)
Sheets("固定格式").Cells(K, "C") = arr(i, 3)
Sheets("固定格式").Cells(K, "D") = arr(i, 4)
Sheets("固定格式").Cells(K, "E") = arr(i, 7)
Sheets("固定格式").Cells(K, "I") = arr(i, 8)
K = K + 1
End If
Next
Application.ScreenUpdating = True '恢复屏幕刷新
Application.DisplayAlerts = True
End Sub |
|