Consolidate in Excel
Description : Excel Consolidate helps you to consolidate your sheets/worksheets into one worksheet.Here we are going to consolidate 3 sheets unit1 , unit2 and unit3 to one sheet. the three sheets are shown below. Excel tips and tricks by +belazy .
How to sum up all the data in separates sheet into one
 |
| Receipts and Disbursement |
Receipts and Disbursement of a single unit
 |
| Receipts and Disbursement |
 |
| Receipts and Disbursement |
Now click on the consolidate icon, it will be available in Data tab in excel 2010.
A window will be open now, choose function as Sum (here we are going to sum up all the sheets)
click on the reference, choose the data table in sheets ancd click on add
check Top row & Left Column.
 |
| Consolidate Sheet |
Consolidated excel sheet
To view the video tutorial : click here
To Know more about Cash Receipts and Cash Disbursement method in accountancy click here
Where to use :
Author : +belazy
Thanks to +deepajayaprakash payyanakkal for her support
+Consumerfed IT Division
Similar posts
create a commodity sales graph
multiple user sharing a excel sheet
Similar posts
- Taking reports using pivot table in ms office excel
- How to share an microsoft office excel to work multiple user simultaneously
- consolidate many table to one using consolidate option in ms office excel
- Working with pivot table in microsoft office excel 2010
- working with share point in microsoft office
- create a internal chat application in organization
http://javabelazy.blogspot.in/
I delight in, cause I found exactly what I used to be having a look for.
ReplyDeleteYou've ended my 4 day long hunt! Godd Bless you man. Have a great day.
Bye