LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 46
Default hyperlink - clicking on hyper link to select cell in another sheet

Good morning,

Could someone please help with the below problem.

I am new to this function in excel and after searching the community cannot
find the answer to my question.

I have a workbook with 6 sheets and have been assigned the task of creating
links within some sheets that will take the user to a certain section of
another worksheet.

I gather that hyperlink is somehow my answer.

My first link is in worksheet "Front Sheet" and named "Click here for
Material Damage Section" in cell D19. By clicking on this the user should
be taken to worksheet "Quote Sheet" cell A1.

My second link is in worksheet "Front Sheet" and named "Click here for Road
Risks Section" in cell D21. By clicking on this the user should be taken to
worksheet "Quote Sheet" cell A56.

As I understand, should I be using the hyperlink functions and have done
this, however, I require the target cell to be in the top left corner of the
worksheet. At present the link only places the target cell at the bottom
of the worksheet when the user is taken there.

Please help,

Thanks

Aaron

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a hyper link to a cell comment Christopher Buxton Excel Discussion (Misc queries) 6 June 25th 07 07:20 PM
Hyper link To PDF DaveKC Excel Discussion (Misc queries) 0 February 16th 07 03:38 PM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
Select one variable from a list of variables by clicking one cell Curt Excel Discussion (Misc queries) 2 July 21st 05 01:44 AM
Mouse continues to select after clicking on a cell in excel. Fletch Excel Discussion (Misc queries) 4 February 22nd 05 02:27 AM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"