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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.