Table Relative Reference copy/Paste Issue

Copper Contributor

I'm working on a macro that will basically take information from a data dump worksheet and copy/paste certain columns into 6 additional sheets. 
Because this macro will be used across multiple teams, the formulas need to be dynamic since the column locations will most likely be different with each data export.
The issue I'm having however is with the formulas, this hyperlink one for example:
=HYPERLINK([@[IssueUrl]],[@[ShortId]])
when copied onto the second sheet from the data dump sheet, it wont filter with the data on the second sheet. if any filters are changed on the data sheet, however, the second sheet changes as well.
I've tried the below variations as well with the same issue:
=HYPERLINK(Table1[[IssueUrl]:[IssueUrl]],Table1[[ShortId]:[ShortId]])
=HYPERLINK([IssueUrl],[ShortId])

 

0 Replies