Click on Summary Tab to set Filter in detail Tab

[excelmr]

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

[Chance2]

You could use code like this on the summary (right click on tab and View Code) tab:

Please Login or Register  to view this content.

[Leith Ross]

Hello excelmr,

Add this code to the "Summary" sheet.

Please Login or Register  to view this content.

[excelmr]

Chance 2 - Your code worked. Thanks for your time.

[excelmr]

Leith Ross - Your code did not worked.

[Leith Ross]

Hello excelmr,

It worked for me. I can only assume you did place the code in the proper worksheet module.

[excelmr]

Leith

There are 2 issues with your code.

1. When click on count next to "Acknowledge", the cursor stayed in Summary Tab. The cursor should take to Detail Tab
2. When click on count next to "External" , the detail tab show no records. That's not correct

[Leith Ross]

Hello excelmr,

You should recheck the workbook you posted. There is no "External" listing.

Here is the workbook with the change to switch to the "Detail" sheet. Everything else is the same as you posted.

[excelmr]

Leith,

When click on "2" next to external, activate the "detail" tab. Filter the "Source" column of "detail" Tab which should show only 2 records having values "External".
Same way when click on "5" filter out "Source" column and show 5 records having values "in-house".

Source Count
=============
External 2
In-house 5
Internal 2

[Leith Ross]

Hello excelmr,

Here is what I have on the "Detail" sheet in the workbook that was posted. This is from your original post.

Please Login or Register  to view this content.

Do you see any entry labeled "External" in the table? I don't.

Are you saying the macro is to repeatedly include the entry into the "Detail" table based on the count?

NOTE: Nevermind, I really need more sleep. Coffee is not working.

[excelmr]

Leith-- Under "Summary" Tab ,below are the values. When you click on the values next to "Acknowledged", Delivered and "In Progress" . The filter works
under "Detail" tab. But when click on the values next to "External","In House", internal the filter does not work. You should activate "Detail" sheet, when
click on the values next to "External","In House", internal

SUMMARY TAB
============

Status count
=============
Acknowledged 4
Delivered 4
In Progress 1

Source Count
=============
External 2
In-house 5
Internal 2