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 |
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 |
All times are GMT +1. The time now is 11:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com