98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel+xp+training - Linking Excel worksheets
excel+xp+training - Linking Excel worksheets
Resolved · Low Priority · Version Standard
Lucy has attended:
PowerPoint Introduction course
Linking Excel worksheets
How do you link numerous cells in seperate worksheets to show a total figure in the last work sheet?
Thanks
Lucy
RE: Linking Excel worksheets
Hi Lucy
Almost 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.
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 tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |