Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel+xp+training - Linking Excel worksheets
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel+xp+training - Linking Excel worksheets
Resolved · Low Priority · Version Standard
Reply
Linking Excel worksheets
How do you link numerous cells in seperate worksheets to show a total figure in the last work sheet?Thanks
Lucy
For upcoming training course dates see: Pricing & availability
RE: Linking Excel worksheets
Hi LucyAlmost the same way that you would in a single worksheet.
Start by typing your formula type e.g. =SUM(
Then move to the worksheet you want and select the cell you want
You then need to insert either a comma or a plus sign to stop the selected cell changing when you move worksheets, but once you've done that just keep repeating the last two steps until you've selecteed all the cells you want, then hit return.
Hope that helps
Tristan
RE: Linking Excel worksheets
Or to link using a 'cookie cutter' formula is a quick when you have many many sheets and it is always the same cell ref that you want:Type:
=SUM('firstpagename:lastpagename'!A1:A1)
BUT beware, if you drag a sheet into or out of this range it will add/drop a cell. Warn yourself with something visual by having a blank first and last sheet that you name FIRST and LAST as you'd have to drag a sheet over that one to enter/exit the range.
|
 |
|
» Forum post: Import data that is stored in an Access 2003 db into Excel 2003 |
I need to link to data in a password protected Access 2003 database from Excel 2003.
