Click on cell link to another worksheet in same workbook

J

JOE

New to Excel 2007.
Baseline data (seperate sheet) with a list of all utility accounts (hydro,
gas - two seperate sheets). I want to click on account number in baseline
and the link to bring me to the utilty account sheet, i.e. hydro (where it
will have all monthly data from 2006-present). Not 3-D referencing.
 
E

Eduardo

Hi Joe,
You can achieve that with Hyperlink, select the cell with the account #,
right click in the mouse, last option is Hyperlink, from the menue in your
left select Place in this document, and select the proper sheet, click ok and
you are done

If this helps please click yes, thanks
 
Top