excel training class - Working with multy work sheet

Hi Jean-paul

Yes, you are able to summarise 4 quarterly worksheets ijn a global results sheet in Micrsoft Excel.

To do this, you need to be familiar with the FORMULAS in Excel.

=A1+B1

That formula will work in a single worksheet.

To extend that thinking, to link to a separate worksheet, simly add the worksheet name to the beginning of the cell reference, including an exclaimtion mark (!) to sparate the name and cell reference.

ie.
=Sheet1!A1+Sheet2!B!
This will add together Cell A1 from sheet1 and Cell B1 from sheet2

The next step would be to extend tha thinking even further, and add 4 cells from 4 different sheets. These would be your quarters. Start with your active cell in the RESULTS sheet, and then create a formula something like this:

=Qtr1!A1+Qtr2!A1+Qtr3!A1+Qtr4!A1

This will add all 4 cells from the various sheets. If you copy the formula down, you will see that due to relative referencing it will change and add the next set of cells downwards:

Ie.
=Qtr1!A2+Qtr2!A2+Qtr3!A2+Qtr4!A2

This should address your question.
Let me know if you want any further information on this.
You are welcome to post any further questions you have on any Microsoft Office applications to this forum.

Regards

Richard
Microsoft Office Specialist