troubleshooting Question

How to create a dynamic hyperlink to a cell in a pivot table?

Avatar of fredgcook
fredgcook asked on
Microsoft ExcelMicrosoft Office
4 Comments1 Solution2552 ViewsLast Modified:
I am building a dashboard where difference sections reference multiple pivot tables. I enter the date for the dashboard in a cell (A8) and use that cell in the GetPivotData function (H1) to pull data for a specific month from the pivot table. Now I would like to be able to click a hyperlink in the same cell that has the GetPivotData formula (H1) and go to that part of the pivot table. Maybe I am missing an easier way to do this, but I have had difficulty creating a hyperlink that looks to another field for part of the string.  For example, I will enter 7/31/13 in cell A8.  I put A8 in the GetPivotData string so that cell H1 in my dashboard shows pivot table data for 7/31/13.  If I change cell A8 to 6/30/13, then the data in H1 in the dashboard automatically shows pivot table data for 6/30/13.  I would like the hyperlink in H1 to automatically go to the correct cell in the pivot table based on the date entered in cell A8.  Thanks for your help.
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros