View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mikey C Mikey C is offline
external usenet poster
 
Posts: 7
Default Use a hyperlink to display a selection of cells on another sheet (in same workbook)

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 :-)