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