Filter pivot table on mouse click selection

Hi gurus. I'm back once again for help. I have the attached file that I'm using as a test file as I cannot upload file that contains company info. It's a very similar format to the company file but contains no real life data.

What I'm looking to do is be able to click the "PN" in the 'Forward' sheet and have the 'Data Pivot' automatically filter the "PN" as a report filter. I know I can copy and paste the "PN" in the search bar in the report filter but I have to make this file easy to use for the managers. In the file that I have the real data, I'll have all the different items that are associated with each business unit broken out in their own sheet. For this example, 'Forward' is a business unit.

Here's a little background info on the data in the file. The 'Data Pivot' is just a pivot of the 'Data' sheet but filtered out to only see the data for Item 13. The 'Forward' sheet breaks out exactly how much time was charged for each PN associated with it. The hours are gathered using sumifs function. The data in the 'Data' sheet is a data entry for every time an employee charges time to whatever it is they are doing.

Don't hesitate to ask me to clarify something. Thanks in advance!!!


High driver test file internet.xlsm

bump

man, one day and it's already on page 10

bump again

bump. somebody please help lol

Hi donkey1,

Your attachment doesn't have a sheet named "Forward" so your description is a little hard to follow.
Did you intend to rename sheet "Item 13" to 'Forward"?

If I'm understanding what you want, try pasting this Event Code into the Sheet Code module of the sheet with the PN values to be clicked. (Right-click on the Sheet Tab > View Code to get to the correct code module).

There's an optional statement that will activate sheet Data Pivot if you want the user to see the filtered pivot.

Please Login or Register  to view this content.

If you plan to have multiple "Item ##" sheets that will provide this same functionality, then this code could be modified to run from the ThisWorkbook module or called from a Standard Code Module by multiple sheets.