|
本帖最后由 bianchi 于 2012-1-14 21:29 编辑
如何複製sheet1 符合條件的列到 sheet 2 ? 列可以是多條 , 我研究了很久也不能 , 請大大幫忙 !!
本帖最后由 sunjing-zxl 于 2012-1-14 22:00 编辑
- Sub aa()
- Dim arr, arr1
- Dim i As Long, n As Long, m As Long
- Application.ScreenUpdating = False
- n = InputBox("输入数据", "输入条件数据")
- arr = Range("A2:A" & [A65536].End(xlUp).Row)
- ReDim arr1(1 To UBound(arr), 1 To 1)
- m = 0
- For i = 1 To UBound(arr)
- If arr(i, 1) = n Then
- m = m + 1
- arr1(m, 1) = i
- End If
- Next i
- m = 0
- For i = 1 To UBound(arr1)
- If arr1(i, 1) = "" Then
- Exit For
- Else
- m = m + 1
- Rows(arr1(i, 1) + 1).Copy Sheets("sheet2").Cells(m, 1)
- End If
- Next i
- Application.ScreenUpdating = True
- End Sub
-
复制代码不清楚你的目的,我猜了一个。不知道是不是你要的结果
|
|