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
CAclubindia
