<div>
TO clarify, above will return any entry containing MOT or Service.
</div>


TO clarify, above will return any entry containing MOT or Service.

<div>
<div class="content wysiwyg-content">
I'm sure for anyone with some VBA experience this will be easy as, but for me who has no clue I don't know where to start. <br />
<br />
I have a macro pulling data from one sheet with an autofilter on and pasting the data on another:<br />
<br />
<i>Range(&quot;V3&quot;).Select<br />
&nbsp; &nbsp; ActiveSheet.Range(&quot;$A$1:$A<wbr />G$999&quot;).Au<wbr />toFilter Field:=28, Criteria1:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;Service&quot;<br />
&nbsp; &nbsp; Range(&quot;A1:AG999&quot;).Select<br />
&nbsp; &nbsp; Range(&quot;V3&quot;).Activate<br />
&nbsp; &nbsp; Selection.Copy<br />
&nbsp; &nbsp; Sheets(&quot;Email Data&quot;).Select<br />
&nbsp; &nbsp; ActiveSheet.Paste</i><br />
<br />
All i want to do is simply enter another option e.g.<br />
<br />
&nbsp; &nbsp; ActiveSheet.Range(&quot;$A$1:$A<wbr />G$999&quot;).Au<wbr />toFilter Field:=28, Criteria1:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;Service&quot;<b> or &quot;MOT&quot; or &quot;Service And MOT&quot;</b><br />
<br />
but as you will probably notice I have no idea of how to do this. How exactly should i type this into VBA please so it doesn't just pull the &quot;service&quot; data but also the &quot;MOT&quot; and the &quot;Service and MOT&quot;?
</div>
</div>


I'm sure for anyone with some VBA experience this will be easy as, but for me who has no clue I don't know where to start. 

I have a macro pulling data from one sheet with an autofilter on and pasting the data on another:

Range("V3").Select
    ActiveSheet.Range("$A$1:$AG$999").AutoFilter Field:=28, Criteria1:= _
        "Service"
    Range("A1:AG999").Select
    Range("V3").Activate
    Selection.Copy
    Sheets("Email Data").Select
    ActiveSheet.Paste

All i want to do is simply enter another option e.g.

    ActiveSheet.Range("$A$1:$AG$999").AutoFilter Field:=28, Criteria1:= _
        "Service" or "MOT" or "Service And MOT"

but as you will probably notice I have no idea of how to do this. How exactly should i type this into VBA please so it doesn't just pull the "service" data but also the "MOT" and the "Service and MOT"?

Multiple Criteria Selection with VBA on an Autofilter

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.