+ Reply to Thread
Results 1 to 3 of 3

Filter based macros to be further filtered by drop down selection?

  1. #1
    Forum Contributor
    Join Date
    02-20-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    133

    Filter based macros to be further filtered by drop down selection?

    I have some macro buttons which filter data on time frames... They are housed in Sheet1 and they filter Sheet2.
    An example of one is:

    Please Login or Register  to view this content.
    I'd like a combo box in Sheet 1, which contains a drop down list of supplier names. Supplier names are housed as a list in Sheet6 and are selected in Column D of Sheet2.
    Is it possible that a supplier can be selected from the combo box, and then one of the time frame buttons is clicked, which applies the time filter but now also filters column D of Sheet2 to the specific supplier?

    For this example lets say the supplier list will be:
    All
    Supplier 1
    Supplier 2
    Supplier 3
    Supplier 4

    I may have made this way more complex than I need to, but I'm not sure how to adapt the above code to cater for this additional filter.

    Thanks in advance.



    also posted here

  2. #2
    Forum Contributor
    Join Date
    02-20-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    133

    Re: Filter based macros to be further filtered by drop down selection?

    Anyone able to advise on this? thanks

  3. #3
    Forum Contributor
    Join Date
    02-20-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    133

    Re: Filter based macros to be further filtered by drop down selection?

    I've managed to adapt the below which seems to be working for what I am after although I'm sure it's not the best method:

    Please Login or Register  to view this content.
    Can it be adapted so that "All" is also a selection choice, which doesn't apply any filters to column D, and that this is always the default?
    Last edited by JRC1; 03-21-2017 at 06:26 AM.

+ 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] VBA to Amend the Filter Selection on a Pivot Table Based on a Drop Down List
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-22-2017, 10:00 AM
  2. Replies: 2
    Last Post: 05-31-2016, 01:55 PM
  3. filter and copy filtered data to another sheet based on combobox selection
    By prince82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2015, 11:09 PM
  4. [SOLVED] Filter/Hide rows in a table based on drop-down selection?
    By kestefon in forum Excel General
    Replies: 4
    Last Post: 01-21-2015, 11:12 AM
  5. Replies: 3
    Last Post: 06-26-2013, 07:51 PM
  6. Replies: 1
    Last Post: 06-03-2013, 06:30 AM
  7. Changing Pivot Report Filter based on Drop Down List Selection
    By rajuasq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 11:40 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