multiple ledger
 

Dear All,

I have the following data in an Excel sheet.

date account Amount
20-07-07 abc 10
22-07-07 xyz 20
24-07-07 def 30
26-07-07 def 40
28-07-07 abc 50

I need to create new sheet on the name of account in which they have
just their realted data including running balance e.g a new sheet with
"abc" and following data

date account Amount Running Balance
20-07-07 abc 10 10
28-07-07 abc 50 60

Anybody can help me

Thnx