Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Click on cell link to another worksheet in same workbook
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. -- JOE :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Click on cell link to another worksheet in same workbook
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 "JOE" wrote: 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. -- JOE :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Click Cell with link should take you directly to source | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
How do I link one TEXT cell to others in a worksheet and workbook. | Excel Worksheet Functions | |||
Excel: How do I set up a cell to click it to link a database? | Excel Discussion (Misc queries) | |||
Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions |