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