im trying to write a series of hyperlinks to named cells in the same workbook
for example
hyperlink stk001 on sheet1 will link to the cell with text stk001 in sheet2
i need to do this for stk001 - stk 999 so id like to be able to copy it down
the spreadsheet and i want the hyperlinks to adjust if i add rows in to
sheet2 which is why i want them linked to a named cell
thank you for your time and assistance
barry
spokane, wa