请先保存好副本,只有数据格式要自己重新设置了- Sub test()
- Dim br, arr, brr(), r, c, x, y
- br = Range("a1:h" & [a65536].End(xlUp).Row)
- arr = Range("i1:p" & [i65536].End(xlUp).Row)
- For c = LBound(arr, 2) To UBound(arr, 2)
- If arr(1, c) >= 0.6 Then
- y = y + 1
- ReDim Preserve brr(1 To 23, 1 To y)
- For r = LBound(arr) To UBound(arr)
- For x = 1 To 23
- brr(x, y) = arr(x, c)
- Next
- Next
- End If
- Next
- Sheets("百分比筛选").Range("l1").Resize(23, 8) = br
- Sheets("百分比筛选").Range("t1").Resize(23, y) = brr
- y = 0
- Erase brr
- For c = LBound(arr, 2) To UBound(arr, 2)
- If arr(2, c) <= 3 Then
- y = y + 1
- ReDim Preserve brr(1 To 23, 1 To y)
- For r = LBound(arr) To UBound(arr)
- For x = 1 To 23
- brr(x, y) = arr(x, c)
- Next
- Next
- End If
- Next
- Sheets("最大未报筛选").Range("l1").Resize(23, 8) = br
- Sheets("最大未报筛选").Range("t1").Resize(23, y) = brr
- erase brr
- set br=nothing
- set arr=nothing
- End Sub
复制代码 |