Update a hyperlink in excel spreadsheet

[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?

 

[Sheeloo]

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

 

[rhhince]

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.

 

[Sheeloo]

That is what it will do if the formula in A1 evaluates to A12000

 

[rhhince]

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.

 

[Sheeloo]

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