Deal All,

I have the following data in a file

JV # JV Dt Party Amount
1 21-07-07 abc 10
2 22-07-07 def 20
3 23-07-07 xyz 30
4 24-07-07 def 40
5 25-07-07 xyz 50

I need to create a macro that should prepare individual sheets for all
parties e.g "xyz" and has the following data

JV # JV Dt Party Amount Running Balance
3 23-07-07 xyz 30 30
5 25-07-07 xyz 50 80

Anybody can help me,

Thnx in advance.