Index sheet based on print pages

[Paolo Lombardi]

Hello NG

I have a wokbook with several sheets. One of these is the final output that
I use for presentations and printing. It is organized as a number of pages
where each page is a summary of key financials for a brand, all the pages
being of the same size, one above the other.

I would like to know it there is any way to automatically create an index
sheet with hyperlinks that refer to these pages. I know there are utilities
that work if the workbook is organized in separate sheets, but I have found
none that works with ranges separated only by page breaks.

Any help will be very appreciated.

Ciao
PL

 

[Dave Peterson]

You can use a worksheet formula to hyperlink to an address on any sheet.

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)