xlsx

Credit/Debit Note complete data in PIVOT in Excel

  Download   Preview

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
Srinivas Chilagani

on 12 February 2020

Other files by the user
866 times
18 KB

Download Other files in GST category


Share Report
Comments

CAclubindia's WhatsApp Groups Link


Trending Downloads

xlsx
Cash/Bank Payment Voucher Format in Excel
On : 02 August 2025
Download
xlsx
Billing Format for Sole Proprietors and Independent Workers
On : 02 August 2025
Download

view more



CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess

Follow us

Popular Files


  1. Report of the Select Committee on Income Tax Bill 2025
  2. Cash/Bank Payment Voucher Format in Excel
  3. Billing Format for Sole Proprietors and Independent Workers