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
875 times
18 KB
Comments
Trending Downloads
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
