|
Public Sub 提取不同列的数据()
Dim arr, arrs
Dim x, y, k, n As Integer
n = Range("u1")
Dim arrs1(1 To 10000, 1 To 3)
arr = Range("a1:c" & Range("c65536").End(xlUp).Row)
arrs = Range("k1:m3")
For y = 1 To 3
For x = 1 To UBound(arr)
If arr(x, y) = arrs(1, y) Then
For k = 1 To n
arrs1(x + k, y) = arr(x + k, y)
Next k
End If
Next x
Next y
Range("ab1").Resize(UBound(arrs1), 3) = arrs1
Range("ab1").Resize(UBound(arrs1), 3).SpecialCells(xlCellTypeBlanks).Delete
End Sub |
|