关于 Excel 问题

Dogs1985

Name	Position	Age
Ai	Student	5
Bi	Teacher	30
Ci	Student	20

假如这个是 sheet 1 ，我可以把凡是有年龄大过 15 的都显示在 Sheet 2 里。应该怎么做？

Dogs1985

回复 2# SotongJiang

我要原本在 sheet 1 ，在 sheet 2 变成只是显示两个的。怎样做呢？

                                               

Name	Position	Age
Ai	Student	5
Bi	Teacher	30
Ci	Student	20

Sheet1
                                               

Bi	Teacher	30
Ci	Student	20

Sheet2

chaiyuen123

回复 4# SotongJiang
Does anyone have a macro or could point me to a way that I could conditionally copy rows from one worksheet to another in Excel 2007.

I'm pulling a list of data from Sharepoint via web query into a blank worksheet in Excel, and then I want to copy the rows for a particular month to a particular worksheet (e.g., all July data from Sharepoint worksheet to the Jul worksheet, all June data from Sharepoint worksheet to Jun worksheet, etc.).

Sample data -
Date - Project - ID - Engineer
8/2/2010 - XYZ - T0908-5555 - JS
9/4/2010 - ABC - T0908-6666 - DF
9/5/2010 - ZZZ - T0908-7777 - TS

Please can anyone help?
Thank You