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

--
Message posted from http://www.ExcelForum.com

Couldn't you record a macro when you did this one time manually?

"PeterW <" wrote:

Hi

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

I would like to -
i) add a hyperlink in say Column A of "Worksheet B", so that I can
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 can
navigate back to the copied data in "Worksheet B".

Any help would be greatly appreciated.

Thanks
Peter

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

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

--
Message posted from http://www.ExcelForum.com

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!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.

"PeterW <" wrote:

Thanks for the response Dave

I have tried this, but unfortunately copying the Hyperlink function
does not remember the original linked address (ie it doesn't remember
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
Peter

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson