Skip to main content
3 of 3
edited tags

Jump to cell address mentioned in other cell

A1 shows address of last cell un a column (e.g. A572 or A577). Every time address will change if adding new row (there can be blank rows in between of rows with data). I need a link in B1 to click and jump on cell with address shown in A1. I know that can do F5 and type Address in a Go To bar. Just want to eliminate extra steps.