Excel

S

Susan

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??
 
E

Elkar

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
 
S

Sandy Mann

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
[email protected]
[email protected] with @tiscali.co.uk
 
Top