98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Working with multy work sheet
excel training class - Working with multy work sheet
Resolved · Low Priority · Version Standard
Jean-paul has attended:
Excel Intermediate course
Working with multy work sheet
Would I be able to summarise 4 Quaterly work sheet, in a global result sheet
RE: 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
RE: working with multy work sheet
Richard,
I have practice today the solution You offered,
Works well.
Thank You.
Can I use the same process to transfer Block of cells, from multi work sheets to a global result sheet.
Appreciate Your help.
Happy new Year,
Jean Paul
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:Move to edge of data blockWhen data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys. |