Update a hyperlink in excel spreadsheet

  • Thread starter Thread starter rhhince
  • Start date Start date
R

rhhince

I have a number in cell A1 that counts the rows in use, say 11000.
I have a hyperlink that I use to go to the bottom of the spreasheet in
cell A2 to reference row 11000.
However, every time I paste data cell A1 changes to read 12000. In
order to reference row 12000, I must change the hyperlink info
manually. Is there a simple code to automatically change the hyperlink
to reference row 12000?
 
In A1 enter a formula which results in a string like
A11000 or whatever the last cell is
Define a name (INSERT->NAME_>DEFINE, say, LASTCELL as
=INDIRECT(A1)

Now insert a hyperlink, in A2, to
LASTCELL
 
That worked out, but I was not entirely clear on the description of
the problem. I want to reference row 12000 and go there when I press
the hyperlink. Thanks for that help though.
 
I did exactly that. A1 formula is: =INDIRECT("A"&$A$5). The formula in
A5 counts the rows in use. I defined the name as BOTTOM. Cell A1 gave
me 35400. Just below that A2 is a hyperlink referencing BOTTOM. When I
press the hyperlink it directs me to cell A1, not cell A35400 which is
the goal. Probably getting closer. Thanks again.
 
Since A5 has 35400,
Define BOTTOM as 'refers to;
A1
Enter this in A1
="A" & $A$5
so that you get A35400.
Insert Hyperlink referring to BOTTOM
Now redefine BOTTOM as 'refers to;
=INDIRECT(A1)
[For a reason I do not understand, BOTTOM does not show up in Hyperlink
dialog if it has INIRECT formula... Hyperlink works if you change the formula
for BOTTOM later]

with A1 as
 
Back
Top