+ Reply to Thread
Results 1 to 5 of 5

Autofilter 2 criteria

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Autofilter 2 criteria

    Hi guys
    the below code works a treat, to filter "loaded" before copying all other entries to another sheet, but I need to filter on 2 criteria "loaded" and "Stock Destroyed", I have tried a few things, but cannot seem to get it to work by omitting both criteria before it copies to another sheet, both the criteria are in the same field

    any help would be appreciated

    scouse13


    Please Login or Register  to view this content.
    Last edited by alansidman; 05-24-2016 at 05:44 AM. Reason: fixed code tags

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Autofilter 2 criteria

    Your closing [/CODE] tag is wrong, please amend it.


    Maybe this?
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: Autofilter 2 criteria

    thanks for the quick reply Millz

    tried that bit of code but keeps coming up saying compile error, expected: named parameter?

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Autofilter 2 criteria

    how about:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: Autofilter 2 criteria

    thanks for your help, managed to sort it played about with the code, seems to work using the below


    .AutoFilter Field:=18, Criteria1:="<>*Loaded*", Criteria2:="<>*Stock Destroyed*"

    scouse13

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-16-2013, 08:33 AM
  2. [SOLVED] Autofilter with multiple criteria - how to ignore blank criteria
    By MOONDRIFT47 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2012, 12:20 PM
  3. Replies: 2
    Last Post: 07-06-2012, 11:42 AM
  4. Need to add criteria #3 to the autofilter... how do I?
    By slicksilver79 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 05-22-2012, 07:48 AM
  5. AutoFilter Criteria, help please.
    By AlanY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2011, 04:59 PM
  6. AutoFilter Criteria
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2009, 03:49 AM
  7. autofilter macro: goto the next criteria down until certain criteria is reached
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-27-2008, 04:31 PM
  8. AutoFilter Criteria in VBA
    By maverick_abhi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2007, 05:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1