Link to another worksheet

[Rae]

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

 

[igorek]

your best bet is to use Pivot...