Use a hyperlink to display a selection of cells on another sheet (in same workbook)

[Mikey C]

Hi all

I have used the following formula to create a hyperlink on the main
sheet (in an attempt) to show a selection of cells on another sheet in
the same workbook:

=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!!

Just to add ... the "Contacts" sheet just contains (obviously) a list
of contacts, which in continuous and in alphabetical order. Rather
than just jumping to a particular cell (e.g. the contact company
title) - I want the entire list of contacts for each company to be
visible.

Do you know how I can adjust the link to make it show an area / range
of cells so the associated record will always apear squarely in the
users screen? Or an alternative way to get the same effect?

Thanks

 

[Mike]

Mikey,

Name the range of cells you want to link to by selecting them and then
insert - name - define.

Type something in the cell you want to hyperlink from and then click inset -
hyperlink - place in this document and select the named range you created.

Providing the range actually fits on the screen then the entire range will
be displayed when you follow the link.

Does that help?

Mike