I have a VBA macro written (it's at work so I don't have it here) that creates a hyperlink based on a cell value. It is used to call up data related to the cell value. The displayed text is the cell value. It works fine. Next I create a pivot table that includes the column that this data resides in. What I'd like to be able do is click on the value in the pivot table and have it refer to the hyperlinked value in the original worksheet. Is this possible? I'm using Excel 2013 but use the classic pivot table format.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Look for value in a worksheet from a pivot table
- Thread starter jrayd
- Start date
