+ Reply to Thread
Results 1 to 3 of 3

Creating a Macro that will display the quanitity of rows resulting from filters

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Creating a Macro that will display the quanitity of rows resulting from filters

    So my dear Excel-ent friends. I need your help to create, what I consider a difficult macro. Here are the circumstances:
    1. I create a weekly report of application statuses for work pulling from 5 workbooks.
    2. Each workbook has one template and I use filters to show me how many apps are mainframe or distributed (first column filter; only options are MFME or >MFME) and the second column I use a filter for is work in progress or in que (second column; option WIP or InQ)
    3. I do this for all five workbooks, each correspoding to a business domain. IN TOTAL I pull 20 numbers.
    4. Those numbers are tranferred to a table in the reporting workbook. I then total them under the total columns then create a pie chart for them. I uploaded this screenshot, I hope it will display correctly: weekly report table.PNG
    The difficulty I am encounterig is finding the equation/and/or applying it to a macro that will show the amount of rows resulting from each filter.
    Example: If I run a filter for MFME apps and a second filter for WIP and 4 results will show. I can see that there are 4 by looking down at the lower left portion of the page or by counting.
    I need to link the amount of results into the associated cell on the report worksheet.

    If anyone can provide me with input I would greatly appreciate it.

    Best,
    Blake

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Creating a Macro that will display the quanitity of rows resulting from filters

    May be off track here but can't you just use COUNTIFS to determine how many entries would be selected by the equivalent filter?

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Creating a Macro that will display the quanitity of rows resulting from filters

    Hi Blake

    I could could be misinterpreting what you are looking for but it sounds like you are looking for a count of the end result of various filters when applied to a range.

    Have you considered SUBTOTAL. Check this out:

    http://www.excelforum.com/tips-and-t...28#post2747428

    Sorry if I'm on the wrong track.

    Russell
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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