+ Reply to Thread
Results 1 to 3 of 3

Multiple autofilter on one worksheet working around with combo box ?

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    France
    MS-Off Ver
    2010
    Posts
    260

    Multiple autofilter on one worksheet working around with combo box ?

    Hi,

    Is there by any chance a work around for using a multiple auto filters on one worksheet using combo boxes ? An exmple of dummy data is :

    Sales Rep <-filter here
    Paul 500
    John 600
    Tom 900
    Andy 450
    Mark 300


    Sales by Region <-and here
    North 120
    South 360
    East 480
    West 490
    North East 250
    North West 500
    South West 290
    South East 260

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Multiple autofilter on one worksheet working around with combo box ?

    If you will change each range into Table, each may have autofilter.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Forum Contributor
    Join Date
    05-30-2013
    Location
    France
    MS-Off Ver
    2010
    Posts
    260

    Re: Multiple autofilter on one worksheet working around with combo box ?

    Awesome didn't know about that feature.

+ 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: 1
    Last Post: 01-06-2012, 06:18 AM
  2. Copy and paste autofilter data based on multiple criteria to another worksheet
    By loneman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2012, 03:05 PM
  3. Need vba script to look a worksheet and keep autofilter working
    By alinda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2011, 03:32 AM
  4. Reference Value on Worksheet 1 from Autofilter List on Worksheet 2 with Autofilter
    By goofchick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2010, 03:46 PM
  5. working with multiple combo boxes
    By wiv in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2008, 12:56 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