carry balance to new sheet

Question

Level 1

11 points

carry balance to new sheet

Sorry, this is very basic, but I'm not sure how to get easy questions answered without doing a whole tutorial for which I do not have time right now! I'm trying oto get away from Excel and do it better this time.

Is there a way to carry a balance forward from one sheet to the next?

Is there a way to get a sum of cells on different pages?
Basically, what I need is a management file for the building expenses and rents and so on. I need a balance forward from January to February and so on, so that say C20 on sheet 1 (Jan) would be carried to C15 on the next sheet (feb).

I would also like a year end tally page, so that I could get a total for expenses of a certain thing like Utilities (ie, D4 on each sheet is added on a final sheet)

Is there a way to do these things?

I am using Numbers '09.
Thank you,

Shelley

Posted on Apr 6, 2013 9:48 AM

Reply

Answer 1

Barry

Level 9

60,023 points

Apr 6, 2013 10:24 AM in response to shelley99

Hi Shelley,

Vocabulary is a bit different for Numbers than for Excel.

Sheets are blank canvases, on which Tables, imags, charts and other objects may be placed.

Cells are contained in Tables.

Copying a value from a cell in one Table to another is a simple matter of referencing the cell containing the value.

The reference will include the original cell's address, and the name of the Table containing it.

If the two Tables are on different sheets, the full reference also includes the Sheet name.

For your example, the formula, placed in C15 on the Table named "February" on the Sheet named "Feb" and retrieving the value from cell C20 on the Table named "January" on the Sheet named "Jan" is:

=Jan::January::C20

If the document contains only one Table named "January", the Sheet name may be omitted:

=January::C20

For the Utilities sum, assuming the same naming scheme for Sheets and Tables through the year, you could use the following formula on your YTD totals table. The formula assumes each month name is used to name only one table in the document.

=SUM(January::D4,February::D4,March::D4,April::D4,May::D4,June::D4,July::D4,Augu st::D4,September::D4,October::D4,November::D4,December::D4)

Note that the formula will throw an error message if any of the tables have not yet been created. Tables where D4 is empty, or contains text, will be ignored.

Regards,

Barry

Reply

Answer 2

shelley99 Author

Level 1

11 points

Apr 6, 2013 12:03 PM in response to Barry

This ROCKS! SO much better than Excel (of course). Just what I needed. Thanks, Barry!

Reply