Is it possible to create a hyperlink to a cell in a filtered table on another sheet and have it such that no matter how the table is filtered (i.e. A-Z or Z-A) the link will always point to the cell with the correct data even though it's cell reference has changed?
A|1
orR1|C1
) and press F4 once.