I need to create jump-link buttons on an index page leading to several sheets. Those sheets with names simply have the url <#name> but some sheets have years (2020, 2021, 2022, etc) as names and the url <#2020> will only jump to the line with that number on the index page (kinda logical) but I can’t figure out how else to address the sheet urls with numbers.
I have tried to no avail: #$‘2020’ or just $‘2020’ or #‘2020’. Any help?
Thank you in advance!
never mind … I added the first cell, problem solved. The link needs to look like:
[#2022.A1]