2
I'm using Excel 2003.
I have a hyperlink in cell E4 in worksheet406R
to cell E4 in worksheet104S
. When I move E4 in worksheet104S
to another location (E16) or sort the data in this worksheet, the cell E4 in worksheet406R
still displays the content of the original linked-to cell, but when I click on it, it goes to cell E4 in worksheet104S
(which now contains new data), not to the new location (E16) as it should (but still displays its content). How can this be fixed (go to the new location of the linked-to cell).
2Are you talking about hyperlinks or cell references? – fixer1234 – 2016-02-10T07:08:32.197
1It would be better if there could be an example of what is desired. Hyperlinks do not change on their own. If they need to some macro might be required. – Prasanna – 2016-02-10T08:41:41.837
Please [edit] your question to include some example (mock) data (before and after). See Format Text as a Table for a web utility that will help you to create a nice data table you can paste into your question.
– DavidPostill – 2016-02-10T09:04:03.057Cell E4 in sheet406R contains a hyperlink to cell E4 sheet104S The later cell was cut and pasted to a new location (E16) When clicking on cell E4 in sheet406R, it goes to cell E4, which now contains new data, while it should go to cell E16 – Hany – 2016-02-11T05:07:22.943