Auto-totalling from several worksheets/workbooks | Excel forum

Resolved · Low Priority · Version 2016

Wed 5 Dec 2018, 11:02 Delegate 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:06 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

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