autototalling several worksheets

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version 2016

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

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.


 

Excel tip:

Shared Conditional Formatting

In 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.

View all Excel hints and tips


Server loaded in 0.08 secs.