Balancing

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
 
F

Fred Smith

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
 

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