Hi,
I have a spreadsheet with numerous tabs, that links into a system we use.
The 1st tab is coding that pulls information from the system and populates the second tab. We then format the data and use formulas to provide a report on the 3rd tab.
The issue I'm having is that part of this coding generates a hyperlink back to the system which is being displayed on the second tab (this can't be changed) when I need it on the 3rd. I've attempted to just link the cell using something along the lines of '=Sheet2!A1' but i'm loosing the hyperlink functionality.
Anyone have any ideas??
Best I have is a macro that copies the hyperlink and puts it on the 3rd tab.
I have a spreadsheet with numerous tabs, that links into a system we use.
The 1st tab is coding that pulls information from the system and populates the second tab. We then format the data and use formulas to provide a report on the 3rd tab.
The issue I'm having is that part of this coding generates a hyperlink back to the system which is being displayed on the second tab (this can't be changed) when I need it on the 3rd. I've attempted to just link the cell using something along the lines of '=Sheet2!A1' but i'm loosing the hyperlink functionality.
Anyone have any ideas??
Best I have is a macro that copies the hyperlink and puts it on the 3rd tab.
