?
Solved

Two criterias

Posted on 2014-12-10
1
Medium Priority
?
55 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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