Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to another worksheet
I wish to create a "jump" or link to another worksheet inside the same
workbook. I am creating a workbook Sheet 1 = Detail data Sheet 2 = Summarized data of Detail From Sheet 2, I want to create a link/jump to a cell range or one cell on Sheet 1. Kind of a drill down effect. Management will primarily look at the Summary sheet but wish for them to have the ability to select a cell from sheet 2 (value) that will take them to Sheet 1 - Detail for more information if they choose. Then the question arises that as the Detail data grows, how to maintain the cell range or cell link; not break but update/change the link so that it is not broken? Thanks, Rae |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to another worksheet
your best bet is to use Pivot...
"Rae" wrote: I wish to create a "jump" or link to another worksheet inside the same workbook. I am creating a workbook Sheet 1 = Detail data Sheet 2 = Summarized data of Detail From Sheet 2, I want to create a link/jump to a cell range or one cell on Sheet 1. Kind of a drill down effect. Management will primarily look at the Summary sheet but wish for them to have the ability to select a cell from sheet 2 (value) that will take them to Sheet 1 - Detail for more information if they choose. Then the question arises that as the Detail data grows, how to maintain the cell range or cell link; not break but update/change the link so that it is not broken? Thanks, Rae |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I link data in an excel worksheet to another worksheet? | Excel Discussion (Misc queries) | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |