Hello everyone, I have a few hyperlink cells with the following formula:
It basically takes me to a different sheet with the same cell value as D22 on the current sheet.
It works perfectly, but is there a way to make it center on the selected cell? As it is now, it takes me to the correct cell but just at the border of the screen (which can be up or down) and it can be hard to spot the selected cell.
Thanks
Excel Formula:
=IFERROR(HYPERLINK("#Main!"&ADDRESS(MATCH(Summary!D22,Main!$C$1:$C$50001,0),2),"Test"),"")
It basically takes me to a different sheet with the same cell value as D22 on the current sheet.
It works perfectly, but is there a way to make it center on the selected cell? As it is now, it takes me to the correct cell but just at the border of the screen (which can be up or down) and it can be hard to spot the selected cell.
Thanks