Thread
:
Dynamic Hyperlinks
View Single Post
#
3
Posted to microsoft.public.excel.misc
[email protected]
external usenet poster
Posts: 5
Dynamic Hyperlinks
On Friday, November 13, 2015 at 2:25:25 AM UTC-8, Claus Busch wrote:
Hi Richard,
Am Thu, 12 Nov 2015 13:35:51 -0800 (PST) schrieb
:
I have a workbook with 40 some sheets.
1 is a summary sheet and the others are the detail. Some detail sheets have more than one piece of information.
Each row on the summary sheet has hyperlink that the user can click to see the detail. Presently, to go back to the summary sheet there is a hyperlink that takes the user back to cell A1 of the summary sheet.
in which range in Summary are the hyperlinks and in which cell in the
detail sheets is the hyperlink?
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
In summary, all the hyper links -- there are some 200 of them -- are in column B, the "return" hyperlink on each detail sheet is in J1
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]