I have created a worksheet with 12 tabs (Jan-Dec). I am trying to get a
total for each month using the previous month's total. When I try to get
Jan's total by using Dec's total, I get an error message refering to circular
reference and it cannot calculate the total. What do I need to do??
--
Susan

Why would your Jan total depend on your Dec total? Are you trying to re-use
the same sheets for a new year? If so, you should manually type in the new
Jan total instead of using a formula.

If you're trying to preserve your previous year's data, then perhaps you
should add new sheets (Jan 06, Feb 06, Mar 06, etc...).

HTH,
Elkar



"Susan" wrote:

I have created a worksheet with 12 tabs (Jan-Dec). I am trying to get a
total for each month using the previous month's total. When I try to get
Jan's total by using Dec's total, I get an error message refering to circular
reference and it cannot calculate the total. What do I need to do??
--
Susan

Susan,

I assume that you have a 'rolling spreadsheet' that conitnually cycles
through the months. If so you need to break the cycle. Try recording a
Macro to copy December's cell to January as a value instead of a formula.

--
HTH

Sandy

with @tiscali.co.uk


"Susan" wrote in message
...
I have created a worksheet with 12 tabs (Jan-Dec). I am trying to get a
total for each month using the previous month's total. When I try to get
Jan's total by using Dec's total, I get an error message refering to
circular
reference and it cannot calculate the total. What do I need to do??
--
Susan

Sandy,
Recording a macro did the trick. Thanks so much!!
--
Susan


"Sandy Mann" wrote:

Susan,

I assume that you have a 'rolling spreadsheet' that conitnually cycles
through the months. If so you need to break the cycle. Try recording a
Macro to copy December's cell to January as a value instead of a formula.

--
HTH

Sandy

with @tiscali.co.uk


"Susan" wrote in message
...
I have created a worksheet with 12 tabs (Jan-Dec). I am trying to get a
total for each month using the previous month's total. When I try to get
Jan's total by using Dec's total, I get an error message refering to
circular
reference and it cannot calculate the total. What do I need to do??
--
Susan