To summarize data from separate worksheets, you can use the data consolidation tool in Excel. The worksheets can be in different workbooks or in the same work book. There are two types on consolidation possible with this. One is consolidation by position and the other is consolidation by category. This is a very useful tool in Excel which will help in data consolidation. We will see detailed illustration on how to do this in Excel 2007. #xlsx
1802 times
431 KB
Download Other files in Info Technology category
Comments
Trending Downloads
Trending Online Classes
Popular Files
- TDS in Excel Format
- The A-Z of TDS: A Guide
- Tax Audit Checklist in Excel Format
- GST Accounting Entries
- Income Tax Calculator: New Vs Old Tax Regime (2024-2025)
- HUF Deed Format
- All in One TDS on Salary for the FY 2024-25
- Excel Formulas, Shortcut Keys & Some Accounting Solutions
- TDS on Scrap Purchase in GST: Excel Automated Formulas Format
- Schedule 3 Balance Sheet - Excel Format
CAclubindia
