Requirement: I have a workbook with many pivots many it. Each of the pivots has a field “Request No”. This field has an embedded hyper link in the source data sheet, which when clicked direct us to source.
But when I pivot this data, hyperlink is lost. I need to activate this hyperlink in pivot so can think of following code
Need you help to guide me on how to build up a macro code for following steps.
For each pivot in the workbook,
Look for Pivot field= “Request No”
For All Request No in that column
Apply formula =HYPERLINK(CONCATENATE("http://cormel- itg01:8080/itg/web/knta/crt/RequestDetail.jsp?REQUEST_ID=",Request No),Request No)
This would help me to replace the entire request No with the hyperlink for all the pivots in the workbook.
Appreciate your support on above.
Many thanks !