Hello,
In my own online searching of how to get a hyperlink to work in a PivotTable from the source data, I am coming here for the ultimate help as what I have found doesn't seem to be working! I have never worked with macros or VBA so I am hoping that someone would be able to provide a step-by-step process for making this type of function work for my purposes (if it can work! and if this is the right approach!)
In my Source Data for my PivotTable I have hyperlinks that link to another worksheet in the same workbook.
I would like for my PivotTable to also have these same hyperlinks function (to be able to click on the link and have it take you to the worksheet I have established in the original Source Data link).
Any help you can provide on this is tremendously appreciated!
Please remember - I have not done any work with VBA or macros so if this is the process that is needed then your step-by-step explanation is is so much appreciated!
Thank you!!
For reference: I am running Excel 2010
In my own online searching of how to get a hyperlink to work in a PivotTable from the source data, I am coming here for the ultimate help as what I have found doesn't seem to be working! I have never worked with macros or VBA so I am hoping that someone would be able to provide a step-by-step process for making this type of function work for my purposes (if it can work! and if this is the right approach!)
In my Source Data for my PivotTable I have hyperlinks that link to another worksheet in the same workbook.
I would like for my PivotTable to also have these same hyperlinks function (to be able to click on the link and have it take you to the worksheet I have established in the original Source Data link).
Any help you can provide on this is tremendously appreciated!
Please remember - I have not done any work with VBA or macros so if this is the process that is needed then your step-by-step explanation is is so much appreciated!
Thank you!!
For reference: I am running Excel 2010
