At 16:57 13/08/2024 +0200, Martin Byttebier wrote:
I want to create a hyperlink in a cell on one sheet ... that links to a specific cell in another sheet ... Initially, I used Ctrl+K to add a hyperlink and set the target to a specific cell, such as "Vissen.f31500." This worked fine until I added some rows to the "Vissen" sheet. The target cell shifted, and "Vissen.f31500" no longer pointed to the correct entry ... My question is: Is there a way to make the hyperlink automatically point to the correct entry, even if rows are added or deleted?
I *think* that if you ascribe a name to the target cell and create the hyperlink to that name instead of to the cell address, you will achieve what you require.
I trust this helps. Brian Barker -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
