Steps to PIVOT table type report:
1.Copy the CDNR from A7 cell to data end and past it at A3 cell in DATA sheet of downloaded excel format (Do it month-wise)
2. Fill with 0(Zero) in empty cells in DATA sheet by FIND & REPLACE (CTRL+F) with option
3. Delete INVOICE TOTAL lines rows & 0 filled rows by using filters
4. Go to SUMMARY SHEET, select OPTIONS menu, click on REFRESH button
5. see the report #xlsx
840 times
18 KB
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
- HUF Deed Format
- Income Tax Calculator: New Vs Old Tax Regime (2024-2025)
- All in One TDS on Salary for the FY 2024-25
- TDS on Scrap Purchase in GST: Excel Automated Formulas Format
- IMS under GST
- Depreciation
CAclubindia
