If you organise your data as follows:
Date source Account Value
1/2/06 Cash News 2.50
1/2/06 Debit Food 21.50
1/2/06 Charge Clothes 52.50
1/2/06 Charge News 12.50
1/2/06 Cash Food 31.50
1/2/06 Charge Clothes 102.50
Then a pivot table can easily summarise.
Example
In ROW drag labels of Date and Account
In COLUMN drag label for Source
In DATA drag label for Value
The pivot table will create itself.
Create a second pivot table from the first (Using Source = from
another Pivot Table) if you want an additional view say with Date and
Source as row headings and Account as Column headings.
regards..
--
steven1001
------------------------------------------------------------------------
steven1001's Profile:
http://www.excelforum.com/member.php...o&userid=30757
View this thread:
http://www.excelforum.com/showthread...hreadid=513485