excel training course - Data

Hi Kate,

Thanks for the question

You can summarise data from different worksheets by using the Data consolidation feature.

To consolidate data, choose Data, Consolidate to open the Consolidate dialog box. What you do is highlight a cell you want with data in it then in the dialog box click "Add" that traps the cell, it defaults ot the "Sum" option (change it if you want a different function). Once you have added all the cells click OK. This will sum all the cells you have highlighted.

Hope that helps

Tracy