Tue 10 Apr 2007, 13:37Delegate Susannah said...
Susannah has attended:
Excel Intermediate course
Project Intro Intermediate course
Links
How do I link a worksheet?
Wed 11 Apr 2007, 11:23Trainer Tracy said...
RE: links
Hi Susannah
Thanks for the question
To add cells on different sheets you would use a formula like:
=A1+Sheet2!B1
Where "Sheet2" is the name of the worksheet
Separated with a ! from the cell reference
Simply create the formula like you normally would, but click on the relevant sheets and cells as you create the formula
Hope that helps
Tracy
