+ Reply to Thread
Results 1 to 5 of 5

Dynamic criteria range with advanced filter

  1. #1
    Registered User
    Join Date
    11-14-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Dynamic criteria range with advanced filter

    DYNAMIC CRITERIA RANGE WITH ADVANCED FILTER


    1. I have data in Sheet 1 having 2 columns name Description and Criteria_T and in Criteria_T "*" is used for advanced filtering criteria for text filter i.e. Criteria range

    2. In sheet 2 I have "Criteria_T" Column Header which is having different data and needs to filtered using Criteria_T as "criteria range" which is dynamic as description data keeps on changing.

    Result: I need to filter data in sheet 2 under "Criteria_T" automatically "as I filter down values in description and Range_T(being the criteria Range) in Sheet 1




    Please help me out with vba code.


    Thanks.

    File attached for your reference.
    Attached Files Attached Files

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Dynamic criteria range with advanced filter

    Please Login or Register  to view this content.
    Last edited by nigelog; 01-17-2019 at 08:43 AM.

  3. #3
    Registered User
    Join Date
    11-14-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Re: Dynamic criteria range with advanced filter

    Thanks a lot.

    It works perfectly.

  4. #4
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Dynamic criteria range with advanced filter

    Glad to help, Can you please mark the thread as solved

  5. #5
    Registered User
    Join Date
    04-14-2021
    Location
    Long Island, NY
    MS-Off Ver
    Office 365
    Posts
    37

    Re: Dynamic criteria range with advanced filter

    Quote Originally Posted by nigelog View Post
    Please Login or Register  to view this content.


    Hi Nigelog,

    When you have an opportunity, would you be so kind to look at my code?

    https://www.excelforum.com/excel-pro...ml#post5528073

+ 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. [SOLVED] Advanced Filter Code : Criteria Range More Than 1 Row Breaks Filter
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2021, 04:30 PM
  2. Advanced Filter to Dynamic Range
    By John in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2019, 12:06 AM
  3. [SOLVED] Advanced filter copy to dynamic range?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2017, 02:54 PM
  4. Advanced filter with dynamic critieria range
    By kilvan99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2014, 02:29 PM
  5. Dynamically hide rows for dynamic criteria range of advanced filter
    By Senator685 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2013, 02:08 PM
  6. Advanced filter a dynamic date range
    By oneandoneis2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2006, 03:57 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