If you're formulas are starting in row 1:

=HYPERLINK("#"&CELL("address",Sheet1!A1),"stk"&TEX T(ROW(),"000"))

If you were starting in row 5, you could use:
=HYPERLINK("#"&CELL("address",Sheet1!A1),"stk"&TEX T(ROW()-4,"000"))



BROCK8292 wrote:

i have a hyperlink formula that will adjust when i copy it to the cell below
it
=hyperlink("#"&cell("address",sheet1!a1),"stk001")
stk001 is the name of the hyperlink cell in a1
when i copy this down the page the range adjusts but the cell name doesnt
change
i need it to change to stk002, stk003, etc.
can anybody help
thank you
brock

--

Dave Peterson