Link within same workbook ...

[Mikey C]

Hi all

I have created a menu page on the first sheet of a workbook, with
links which will take a user to the appropriate record in the next
sheet (spreadsheet just records contact details for customers)

The problem is that every time I add another contact (by inserting
rows to keep it in alphabetical order), all my existing links point to
the incorrect cells and thus display the wrong information. I'm using
the insert hyperlink function on the menu.

Does anybody know how to do this without it messing everything up
every time a new record is added?

Thanks for your help folks

 

[Guest]

Hi Mickey:

The following uses the HYPERLINK() function to goto Sheet3 cell Z100:

=HYPERLINK("#"&CELL("address",Sheet3!Z100),"target")

This link will "adjust". So if you add or remove rows above Z100, the
formula will adjust!

Have a good weekend.

 

[Mikey C]

Sorry for the late reply, but thanks very much

 

[Mikey C]

Sorry for the late reply, but thanks very much

Just one more question ...

I have used the following formula
=HYPERLINK("#"&CELL("address",Contacts!A1027:G1054),"target")

The reason I tried to use a range of cells is because I want the
entire 'record' to display in the users view. However, if the Contacts
page is left in position above the required record (from the previous
viewing / save), only the title will show and the user will have to
scroll down to find the details. It has the opposite affect if I
select the last cell of the record - I hope that description made some
sense to you!!

Do you know how I can adjust the link to make it show an area / range
of cells to make it always apear squarely in the users screen?