Thread: multiple ledger
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shaqil shaqil is offline
external usenet poster
 
Posts: 30
Default 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