Credit/Debit Note complete data in PIVOT in Excel
Quick Summary
File details
File description
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
Comments
Recent Files in GST
View more →Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
Popular Files
- Processing Status of Citizen’s Charter Applications as of Sept 30, 2026
- RBI Bulletin - September 2026
- RBI | Report of the Advisory Committee on Ways and Means Advances to State Govts
- Monthly Economic Review - Sept 2026
- ICSI | Exposure Draft of Proposed Syllabus 2027
- ICAI Students' Journal: October 2026 Edition
- CA Intermediate Financial Management and Strategic Management Paper New Course September 2026
CAclubindia
