Private Sub CommandButton1_Click()
Sheet1.Range("$A$3:$I$500").AutoFilter Field:=4, Criteria1:=Array( _
"111", "111-S", "5102", "5201", "5201A", "5201B", "54012", "5401A", "5401B", "5401C", _
"5401D", "7001", "7001B", "7807A", "7807B", "7807C", "8101A", "8101B", "8101C", "8101D", _
"8101E", "8101F", "8101G", "8201A", "8201B", "8201C", "8201D", "8201E", "8201F", "s103") _
, Operator:=xlFilterValues
Sheet1.Range("A1").CurrentRegion.Copy Sheet2.[a1]
Sheet1.Range("$A$3:$I$500").AutoFilter
End Sub
Sub zz()
Sheet1.Range("$A$3:$I$500").AutoFilter Field:=4, Criteria1:=Array("L80", "L80-S"), _
Operator:=xlFilterValues
Sheet1.Range("A1").CurrentRegion.Copy Sheet3.[a1]
Sheet1.Range("$A$3:$I$500").AutoFilter
End Sub
|