Copy new row balance on different work sheet.

[Alfast]

Hi all,

I have got a B sheet in excell in which customers pay us every month a certain amount. I update this accordingly on every row in Collumn F. (like a bank statement)

I have already set a forumula that recognises the credit or debit, so it automaticcaly updates this on Collumn F which ever row its on.

Each sheet is for a seperate customer.

However i now have a A sheet in which i want all the customers up to date balances showing in a new sheet. So row one will have A customer balance, row 2 will have B customer balance , Row 3 C customer balance etc.

How do i tell excell that in B sheet, if new row is entered, the NEW balance is updated to the A sheet cell?

Been trying this for a while, really need help.

Thanks