Hi,
Just wondering if what I'm trying to do is possible.
I am trying to hyperlink all Worksheet2 A cells to worksheet1 A cells according to their row number.
I have tried to create a Hyperlink in A1 and drag it down but what happens is that hyperlink links to same cell adn doesnt change cell number whilst dragging.
Am I making any sence here?
Manual linking isnt very practical as I have 2000 rows to link up
Thanks
Bookmarks