+ Reply to Thread
Results 1 to 2 of 2

advance filter exact match

  1. #1
    Registered User
    Join Date
    12-12-2021
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    19

    advance filter exact match

    HI ALL
    i record a macro for advance filter but i have problem of exact match i have items blue , blue3 , blue 45 ect when i filter its filter all blue i want only blue when i filter blue can some body help me to correct vba code to exact match THANKS

    Sub ITEM_LEDGER()
    '
    ' ITEM_LEDGER Macro
    '

    '
    Sheets("MASTER_SHEET").Range("Table1[#All]").AdvancedFilter Action:= _
    xlFilterCopy, CriteriaRange:=Range("F1:F2"), CopyToRange:=Range("E4:V4"), _
    Unique:=False
    End Sub

  2. #2
    Registered User
    Join Date
    12-12-2021
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    19

    Re: advance filter exact match

    Sorry post again how to delete this post

+ 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. advance filter exact match
    By eja in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2022, 03:20 PM
  2. [SOLVED] VBA to Filter Based on Cell Value - Exact Match Only
    By Bigmal70 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2017, 11:34 AM
  3. How do I make advanced filter do exact match only?
    By blogger153 in forum Excel General
    Replies: 2
    Last Post: 11-29-2015, 11:30 PM
  4. Filter column by exact match?
    By mikey42979 in forum Excel General
    Replies: 6
    Last Post: 06-20-2013, 11:21 AM
  5. [SOLVED] Filter matrix based on a non-exact match
    By douglascaixeta in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-31-2013, 04:32 PM
  6. Filter function - exact match...
    By pmguerra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2006, 09:48 AM
  7. Advance filter search does not filter an exact match
    By cfiiland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2005, 08:05 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