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
|