Solved

Two criterias

Posted on 2014-12-10
1
51 Views
Last Modified: 2014-12-16
Hi,

I have the below code and need to filter on two criterias, my second criteria is

Column 6 "BB"

Can someone amend the below sysntax so this filters first on Column 8 and then on Column 6

Thanks

    Cells.Select
    Selection.AutoFilter
    Cells.AutoFilter Field:=8, Criteria1:="France"

----- no I need it to filter on column 6 for "BB"
     
    Cells.Copy
    Workbooks.Add
   
 
    Range("A1").PasteSpecial
    SaveTheFile_Everything

Thanks
0
Comment
Question by:Seamus2626
1 Comment
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40491988
pls try

    Cells.Select
     Selection.AutoFilter
     Cells.AutoFilter Field:=8, Criteria1:="France"
     Cells.AutoFilter Field:=6, Criteria1:="BB"

'  ----- no I need it to filter on column 6 for "BB"
      
     Cells.Copy
     Workbooks.Add
     
   
     Range("A1").PasteSpecial
     SaveTheFile_Everything

Open in new window

Regards
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question