kinda.. I'll try to explain a little better.
ok, I have value X in book1, sheet1, A1. I would like a hyper link on book2 to link to the cell on book 1. On the text to display for the hyperlink I would like it to show the contents of the cell on book1.
I have done it for different sheets, but not work books. The code I used was
and I wrote this in the 'text to display' box so that on sheet 1 the hyper link displayed whatever was in cell A! on sheet 2 and acted as a hyperlink to that cell.
Thanks again.
Scouse.
Bookmarks