How do i get the running balance from one worksheet to another?
 

How do i get the running balance from one worksheet to another?

i.e withdrawls and deposits will change all the time, so I want this running
balance (subtotal) to transfer to an overview sheet, so I will always have an
up to date total.

if you have the running balance on Sheet1 in a given cell (D4)

on the other sheet
=Sheet1!D4
will transfer the data.


"Spoardy" wrote:

How do i get the running balance from one worksheet to another?

i.e withdrawls and deposits will change all the time, so I want this running
balance (subtotal) to transfer to an overview sheet, so I will always have an
up to date total.

Hiya

Thanks for that, isn't quite what I was looking for but close. I have a
'balance column' that changes with each withdrawl/credit I make. So I need
to transfer the current balance from the 'balance column' onto a seperate
sheet?

Bearing in mind this figure can change frequently.

Does that make sense?

Spoardy.

"bj" wrote:

if you have the running balance on Sheet1 in a given cell (D4)

on the other sheet
=Sheet1!D4
will transfer the data.


"Spoardy" wrote:

How do i get the running balance from one worksheet to another?

i.e withdrawls and deposits will change all the time, so I want this running
balance (subtotal) to transfer to an overview sheet, so I will always have an
up to date total.

assuming your balance column is set up as
=previous balance-current outgo + current input
down to say row 1000

try
=sheet1!D1000

to reflect the value of your last cell in the column. If you have it set up
different than this, le me know.
"Spoardy" wrote:

Hiya

Thanks for that, isn't quite what I was looking for but close. I have a
'balance column' that changes with each withdrawl/credit I make. So I need
to transfer the current balance from the 'balance column' onto a seperate
sheet?

Bearing in mind this figure can change frequently.

Does that make sense?

Spoardy.

"bj" wrote:

if you have the running balance on Sheet1 in a given cell (D4)

on the other sheet
=Sheet1!D4
will transfer the data.


"Spoardy" wrote:

How do i get the running balance from one worksheet to another?

i.e withdrawls and deposits will change all the time, so I want this running
balance (subtotal) to transfer to an overview sheet, so I will always have an
up to date total.

Thanks. I think I have set mine upo different, basically I have copied the
formulas from another excel sheet I had for a while. The formulas they were
using on the balance column is:

=IF(OR(M33=M32,M33=N32),"",M33)

Does this help?


"bj" wrote:

assuming your balance column is set up as
=previous balance-current outgo + current input
down to say row 1000

try
=sheet1!D1000

to reflect the value of your last cell in the column. If you have it set up
different than this, le me know.
"Spoardy" wrote:

Hiya

Thanks for that, isn't quite what I was looking for but close. I have a
'balance column' that changes with each withdrawl/credit I make. So I need
to transfer the current balance from the 'balance column' onto a seperate
sheet?

Bearing in mind this figure can change frequently.

Does that make sense?

Spoardy.

"bj" wrote:

if you have the running balance on Sheet1 in a given cell (D4)

on the other sheet
=Sheet1!D4
will transfer the data.


"Spoardy" wrote:

How do i get the running balance from one worksheet to another?

i.e withdrawls and deposits will change all the time, so I want this running
balance (subtotal) to transfer to an overview sheet, so I will always have an
up to date total.