Results 1 to 11 of 11

Click on Summary Tab to set Filter in detail Tab

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    47

    Click on Summary Tab to set Filter in detail Tab

    I have an excel spreadsheet. When click on count values like "4" , the cursor should go to "Detail" tab and filter the Status column to "Acknowledged".
    So that only status =Acknowledged" records display. The same way when click on "1", only status = in progress record should display.

    See the attached file for better clarification.

    Summary Tab
    ============
    Status count
    ------ -----
    Acknowledged 4
    Delivered 4
    In Progress 1


    Detail Tab
    =======
    Date Status Source
    ---- ------ ------
    1/3/2015 Acknowledged In-house
    1/5/2015 Acknowledged Internal
    1/6/2015 Acknowledged In-house
    1/9/2015 Acknowledged In-house
    1/1/2015 Delivered In-house
    1/4/2015 Delivered In-house
    1/7/2015 Delivered Internal
    1/8/2015 Delivered External
    1/2/2015 In Progress External
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot Table Detail - Macro to double click/show detail
    By popps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2012, 11:28 AM
  2. Summary of a detail list
    By sethup in forum Excel General
    Replies: 1
    Last Post: 07-08-2011, 09:18 AM
  3. How to derive summary totals based on detail?
    By Sun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2010, 12:58 AM
  4. copy detail to summary row in outline
    By Hobbes2006 in forum Excel General
    Replies: 1
    Last Post: 01-20-2006, 03:10 PM
  5. [SOLVED] Pulling selected data from a detail page to a summary
    By Redline in forum Excel General
    Replies: 2
    Last Post: 01-16-2006, 12:10 PM
  6. create detail from summary data
    By hvibberts25 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2005, 01:57 PM
  7. [SOLVED] Summarize multiple worksheet detail on summary sheet
    By 061931 in forum Excel General
    Replies: 6
    Last Post: 05-23-2005, 10:06 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