|
本帖最后由 易安1 于 2014-8-12 22:16 编辑
- Sub test()
- With Sheets("数据").Columns("a:e")
- .AutoFilter Field:=3, Criteria1:="男"
- .Range("a1:e" & .Cells(Rows.Count).End(3).Row).Copy Sheets("结果").[a3]
- With Sheets("结果")
- .Range("a3:e" & .Cells(Rows.Count, 1).End(3).Row).Sort .[d3], xlAscending, Header:=xlYes
- End With
- End With
- With Sheets("数据").Columns("a:e")
- .AutoFilter Field:=3, Criteria1:="女"
- .Range("a1:e" & .Cells(Rows.Count).End(3).Row).Copy Sheets("结果").[G3]
- With Sheets("结果")
- .Range("g3:k" & .Cells(Rows.Count, "G").End(3).Row).Sort .[j3], xlAscending, Header:=xlYes
- End With
- End With
- End Sub
复制代码 |
|