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