Hyperlink

P

PeterW

Hi

I have managed to write some code to copy some data from one workshee
("Worksheet A") to the bottom of a list in another workshee
("Worksheet B").

I would like to -
i) add a hyperlink in say Column A of "Worksheet B", so that I ca
navigate back to the original source of the data in "Worksheet A"; and
ii) add a hyperlink in say Column A of "Worksheet A", so that I ca
navigate back to the copied data in "Worksheet B".

Any help would be greatly appreciated.

Thanks
Pete
 
P

PeterW

Thanks for the response Dave

I have tried this, but unfortunately copying the Hyperlink functio
does not remember the original linked address (ie it doesn't remembe
the worksheet it came from)

I think I will need to write the Hyperlink function programatically..
which I don't know how to do.

Any further help/advice would be appreciated.

Regards
Pete
 
D

Dave Peterson

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

David also has a "build table of contents" macro at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

It might help you with the code.
 
Top