multiple ledger

S

shaqil

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top