HI,
I have been battling the last few days with pulling a referenced column of hyperlinks into a new worksheet.
I have a source worksheet and destination.
On the source worksheet i created the formula =HYPERLINK([@[Improvements'[SW URL']]],[@[Improvements'[Improvement Description']]])
Destination sheet = =Source[@[Improvements'[Improvement Description']]]
Properties i have configured to keep formatting, but with no prevail it comes through as normal text. how can i keep the link? It doesn't even pull in from source to destination now.
Any help would greatly be appreciated
I have been battling the last few days with pulling a referenced column of hyperlinks into a new worksheet.
I have a source worksheet and destination.
On the source worksheet i created the formula =HYPERLINK([@[Improvements'[SW URL']]],[@[Improvements'[Improvement Description']]])
Destination sheet = =Source[@[Improvements'[Improvement Description']]]
Properties i have configured to keep formatting, but with no prevail it comes through as normal text. how can i keep the link? It doesn't even pull in from source to destination now.
Any help would greatly be appreciated
