Results 1 to 4 of 4

VBA macro to update advanced filter not working

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2017
    Location
    San Diego, CA
    MS-Off Ver
    2013
    Posts
    10

    VBA macro to update advanced filter not working

    Hi all,
    Please see attached. The goal is to update only cell P1 which will then populate the filter criteria in columns S:AD, which in return will automatically re-filter the entire sheet to show only rows with the entered value in any of the columns.

    I'm currently using this VBA code:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("E1:O178").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
    ("S2:AD13"), Unique:=False
    End Sub

    I cannot for the life of me get the rows to automatically re-filter after changing P1. Your help is appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Advanced filter.. Not Working..!
    By Vikas_Gautam in forum Excel General
    Replies: 4
    Last Post: 09-29-2014, 11:48 PM
  2. [SOLVED] Input box for range in working macro for advanced filter
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2014, 10:43 AM
  3. Advanced filter not working right
    By Yoden in forum Excel General
    Replies: 6
    Last Post: 08-02-2014, 09:53 PM
  4. Automatic update/repeat of advanced filter?
    By the_adam in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-14-2013, 06:37 AM
  5. Macro or VBA Help needed for Advanced Filter and auto update destination workbooks
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2012, 06:07 PM
  6. Update advanced filter
    By fcb1900 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 08:40 AM
  7. Advanced Filter not working
    By babypenquin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2006, 12:55 PM

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