+ Reply to Thread
Results 1 to 2 of 2

Multiple Auto-filters in One Worksheet

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2010
    Posts
    44

    Multiple Auto-filters in One Worksheet

    Hello,

    I am creating an escalation report for my group. I have a macro that sorts different criteria into a section for our Vice President, Director, and Manager to review different types of issues that need to be escalated. I would like each level (VP, Director, & Manager) to be able to filter for a type of issue they are interested in. Is there a way to add multiple auto filters in the same work sheet?? So far, it is just allowing me to add one filter that is sorting everything together and destorying my report.

    I've tried grouping my sections together, and adding a filter to each section but that wasn't working too well. I tried googling this, but it didn't seem like there was much out there on it. Any suggestions would be appreciated.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Multiple Auto-filters in One Worksheet

    it would be better if u attached sample workbook (remove your sensitive data and some other than ur sensitive data), its make very easy to to resolve ur query
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

+ 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: 4
    Last Post: 07-24-2012, 01:21 PM
  2. Replies: 16
    Last Post: 04-07-2008, 08:12 PM
  3. Replies: 1
    Last Post: 10-24-2007, 08:31 PM
  4. Multiple Auto filters
    By mpquin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2007, 11:49 PM
  5. How can I auto-refresh auto-filters when data changes?
    By Mike@MPWco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-04-2006, 07:55 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