Sub test()
Sheets(2).Cells.Clear
Sheets(1).AutoFilterMode = False
Sheets(1).Range("A1").CurrentRegion.AutoFilter Field:=1, Criteria1:=">=90000", Operator:=xlAnd, Criteria2:="<1000000"
Sheets(1).Range("A1").CurrentRegion.Copy Sheets(2).Range("A1")
End Sub