Friday, June 24, 2011

Generating all ledger Accounts

Method 1 :

Use PivotTable operation.

Method 2 :

1. Make a copy of the data entry sheet.
2. Sort the data based on column Accounts, then by column Date.
3. Do Subtotalling operation.
4. You can collapse/ expand the subtotal tree.
5. You can delete the sheet because you can rebuild easily.

Advantage or disadvantage of each methods

No comments:

Post a Comment