Balancing

  • Thread starter Thread starter Boopathi
  • Start date Start date
B

Boopathi

Hi

I have a excel data range from that I have to create a daily balance
register

Say' in row 1 op value, row2 to row10 contains transcation details, I want a
new row to be inserted in the end of the row (end of the each date) and the
value of row1 & row2 to row10
to be combined in the inserted row

any help ?

Thanks
Raj
 
By "op value" do you mean "opening value". Are transaction amounts to be
added or subtracted?

Why not just keep a running balance. For every row, calculate the new
balance as Old balance + or - transaction amount.

Regards,
Fred
 
Back
Top