98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auto-totalling from several worksheets/workbooks | Excel forum
Auto-totalling from several worksheets/workbooks | Excel forum
Resolved · Low Priority · Version 2016
Wed 5 Dec 2018, 11:02Delegate Sian said...
Sian has attended:
Excel Intermediate course
Auto-totalling from several worksheets/workbooks
Hello,
I need start a workbook that auto-totals information from several worksheets/spreadsheets, is this possible? Are there any online tutorials that can assist with this?
thank you,
Sian
Wed 5 Dec 2018, 12:06Trainer Sarah said...
RE: Auto-totalling from several worksheets/workbooks
Hi Sian
You can achieve this by 'linking' your worksheets/workbooks to your new summary workbook.
This is covered on our Excel Intermediate course that you attended, so if you refer to the 'Linking your Workbook' section of your manual then you will find some information and a step by step guide.
If you prefer watching videos, this Youtube video is also pretty helpful:
https://www.youtube.com/watch?v=CcFWUE954qc
Let us know if you have any more issues or need help with a specific problem with your linking.
Kind Regards,
Sarah
Excel Trainer
Wed 12 Dec 2018: Automatically marked as resolved.
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:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |
