|
发表于 2011-10-29 21:56
|
显示全部楼层
本楼为最佳答案
- Sub 按钮2_Click()
- Dim A, B(1 To 65555, 1 To 4), x%, i&, s&
- With Sheets(1)
- A = .Range("a2:h" & .Range("a2").End(xlDown).Row)
- x = .Range("m2")
- End With
- For i = 1 To UBound(A)
- If A(i, 1) = x Then
- s = s + 1
- B(s, 1) = s
- B(s, 2) = A(i, 6)
- B(s, 3) = A(i, 7)
- B(s, 4) = A(i, 8)
- End If
- Next i
- With Sheets(2)
- .Range("a4:e65536").Clear
- If s > 0 Then
- .Range("a4").Resize(s, 4) = B
- End If
- End With
- End Sub
复制代码
提取复制.rar
(11.98 KB, 下载次数: 14)
|
|