T
Tom H. Lautenbacher
Dear group,
I am using a table with multiple columns that are used as a database.
Each column is one data entry. I am having some hyperlinks that point
from one data entry (i.e. column) to another inside the spreadsheet.
Unfortunately, when I perform a sort of the columns, these hyperlinks
remain pointing to the previous location inside the sheet, i.e. to the
wrong column after the sort.
How do I solve this, i.e. how I make Excel understand that these
hyperlinks need to be updated while sorting the table?
Thank you for any advice
Tom
I am using a table with multiple columns that are used as a database.
Each column is one data entry. I am having some hyperlinks that point
from one data entry (i.e. column) to another inside the spreadsheet.
Unfortunately, when I perform a sort of the columns, these hyperlinks
remain pointing to the previous location inside the sheet, i.e. to the
wrong column after the sort.
How do I solve this, i.e. how I make Excel understand that these
hyperlinks need to be updated while sorting the table?
Thank you for any advice
Tom