Need a Macro code to filter & unselect a specific value.

[Yup]

Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example.

Name	Devices	code
A	Desktop	234
B	Laptop	2345
C	Laptop	3456
D	Smartphone	7654
E	Printer	3456
F	Desktop	098
G	Scanner	123
H	Laptop	65
I	Smartphone	876
J	Laptop	345

I need to filter column "Devices". Unselect "Smartphone". Copy rows & Paste.
But the column "Devices" may contain other values from selective range that may or may not be present every time e.g. Television.
I need a code that will satisfy these conditions.

 

[Fluff]

You can use

 .AutoFilter 3, Array("Laptop", "Desktop", "Smartphone"),xlFilterValues