Hello, I have a spreadsheet with four sheets: "Vissen," "L-nummers," "CW," and "Verwerking."
I want to create a hyperlink in a cell on one sheet (e.g., "L-nummers") that links to a specific cell in another sheet (e.g., "Vissen"). 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 because the original cell became "f31510" or something similar. My question is: Is there a way to make the hyperlink automatically point to the correct entry, even if rows are added or deleted? Ideally, I would like the hyperlink to automatically update based on the target entry. I tried using the formula =$Vissen.f31500 in the "L-nummers" sheet, which works, but it doesn't create a hyperlink. Is there a way to achieve this? Kind regards, Martin -- Atari FTP-site: ftp://kurobox.serveftp.net:3021 Running openSUSE Tumbleweed / KDE 6.1.4 -- 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
