|
跪求代码:如果sheet1中第一列单元格中的日期等于H1,那么要将日期相同的这些行的数字从第二列开始复制到28列,顺序粘贴到sheet2中?
- Sub 提取()
- Dim arr, i%, j%, arr1(), k%
- With Sheets("sheet1")
- arr = .Range("a6").Resize(.[a65536].End(3).Row - 5, 28)
- For i = 1 To UBound(arr)
- If arr(i, 1) = .[h1] Then
- k = k + 1
- ReDim Preserve arr1(1 To 27, 1 To k)
- For j = 1 To 27
- arr1(j, k) = arr(i, j + 1)
- Next j
- End If
- Next i
- End With
- Sheets("sheet2").Range("a6:aa65536").ClearContents
- Sheets("sheet2").Range("a6").Resize(k, 27) = Application.Transpose(arr1)
- End Sub
复制代码
|
|