Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding a hyper link to a cell comment | Excel Discussion (Misc queries) | |||
Hyper link To PDF | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Select one variable from a list of variables by clicking one cell | Excel Discussion (Misc queries) | |||
Mouse continues to select after clicking on a cell in excel. | Excel Discussion (Misc queries) |