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

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.
> > > >
> > > >

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.
> > > >
> > > >