Pivot Table Hyperlinks

[LadyHarper]

Hi,

I need my Master Data Table to transfer Hyperlinks to Pivot table.

I have seen lots of VBA coding, however not much for hyperlinking to computer files and not web links.

Can anyone help me?

 

[Johnny Thunder]

What will a pivot table of hyperlinks be needed for? Might help to understand what your doing. If you wanted to just have a list of hyperlinks why not convert them to plain text and then pivot off of that?

 

[LadyHarper]

I have a spreadsheet and in one of the columns there are hyperlinks to be able to pull up the file that corresponds to that row of information. So I have used the pivot table to all people to search the information quicker and easier but they still need to be able to click the hyperlink once they find the file they are after.

 

[LadyHarper]

My master Table (Tab) the links are in column G and on my Pivot Table (Tab) they need to reflect column G in Column E.

Can anyone help with this?