Creating thousands of hyperlinks in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Megan - 01 Aug 2007 16:03 GMT

I'm creating a huge directory and I'd like to include internal
hyperlinks. Is there a FAST way to do this? i.e. I need to create 2000
hyperlinks, leading from one cell to a cell on another worksheet.
Tips?

Thanks!

Reply to this Message

Dave Peterson - 01 Aug 2007 16:22 GMT

I'd use the =hyperlink() worksheet function.

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)

> I'm creating a huge directory and I'd like to include internal
> hyperlinks. Is there a FAST way to do this? i.e. I need to create 2000
> hyperlinks, leading from one cell to a cell on another worksheet.
> Tips?
>
> Thanks!

Signature

Dave Peterson

Reply to this Message