Partywise BreakUp Report

  • Thread starter Thread starter Sinner
  • Start date Start date
S

Sinner

Hi,


I have an excel sheet with data in which parties ID in column 'C' and
amount, date and other columns etc.
I want a macro solution which would 'generate partywise breakup' in
'sub-total' like format in another single sheet, datewise ascending
order.

Example:

ID Amount
AZ1101 10
AZ1102 20
AZ1103 30
AZ1109 10
AZ1101 10
AZ1101 40
AZ1102 100
AZ1103 80
---------------------
Total = 300


Result should be as below in single sheet.

ID Amount
AZ1101 10
AZ1101 10
AZ1101 40
------------------
Total = 60

ID Amount
AZ1102 20
AZ1102 100
------------------
Total = 120

ID Amount
AZ1103 30
AZ1103 80
 
Hi,

You can use a pivot table to do this. Data, PivotTable and PivotChart
Report...
You can put the pivot table on the same or different sheet, in fact even in
a different wb.

Cheers,
Shane
 
Back
Top