Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
edited tags
Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297
deleted 9 characters in body
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

A1 shows address of last cell un a column (e.dg. 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 I know that can do F5 and tipetype Address in a Go To bar. Just want to eliminate extra steps. Thank you

A1 shows address of last cell un a column (e.d 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 tipe Address in a Go To bar. Just want to eliminate extra steps. Thank you

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.

Source Link
user265478
user265478
  • 11
  • 1

Jump to cell address mentioned in other cell

A1 shows address of last cell un a column (e.d 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 tipe Address in a Go To bar. Just want to eliminate extra steps. Thank you