|
Sub s()
Application.DisplayAlerts = False
On Error Resume Next
Dim sh As Worksheet
Sheets("Sheet2").Delete
Set sh = Worksheets.Add
sh.Name = "Sheet2"
arr = Worksheets("china_sites_20150102").Range("a1").CurrentRegion
For i = 2 To UBound(arr)
If Cells(i, 2).Value = 1 And Cells(i, 3).Value = "PM2.5_24h" Then
Worksheets("china_sites_20150102").Rows(i).Copy Worksheets("sheet2").Range("A65536").End(3).Offset(1, 0)
Worksheets("china_sites_20150102").Rows(1).Copy Worksheets("sheet2").[a1]
End If
Next
Application.DisplayAlerts = True
MsgBox "OK!完成!!!", 48, "温馨提示……"
End Sub |
|