can I link a sheet to another sheet?
 

I want to click or double click on a cell and have it open another sheet that
has details about the original cell. For instance click on Budget sheet B4
"maintenance" and have the sheet "maintenance" open where all the maintenance
costs are listed and balanced.

Thanks

can I link a sheet to another sheet?
 

Jace

InsertHyperlinkPlace in this document.

Of course you would first have to make sure that all the pertinent data for that
cell and its associated data are on the sheet you hyperlink to.

Have you done that part already or are you also looking for a solution for this?

Maybe just using Autofilter on the Budget sheet would be enough?


Gord Dibben MS Excel MVP

On Sun, 10 Jun 2007 09:21:02 -0700, Jace wrote:

I want to click or double click on a cell and have it open another sheet that
has details about the original cell. For instance click on Budget sheet B4
"maintenance" and have the sheet "maintenance" open where all the maintenance
costs are listed and balanced.

Thanks