Formula
 

I have set up a spreadsheet showing charges & payments - s far I have four
pages. How does one set up the total at the bottom of page 1 to be carried
forward to the next Pages ?

Formula
 

When you say "pages", do you mean worksheets? If so, then you can just
reference the cell on Sheet 1 from Sheet 2. Like this:

In a cell on Sheet 2 enter:

='Sheet 1'!A10

This will pull the value from Cell A10 on the worksheet called Sheet 1.
Change the worksheet name and cell reference to match your own.

HTH,
Elkar


"Ricsec" wrote:

I have set up a spreadsheet showing charges & payments - s far I have four
pages. How does one set up the total at the bottom of page 1 to be carried
forward to the next Pages ?

Formula
 

Sorry my mistake, I meant single pages not the whole worksheet

"Elkar" wrote:

When you say "pages", do you mean worksheets? If so, then you can just
reference the cell on Sheet 1 from Sheet 2. Like this:

In a cell on Sheet 2 enter:

='Sheet 1'!A10

This will pull the value from Cell A10 on the worksheet called Sheet 1.
Change the worksheet name and cell reference to match your own.

HTH,
Elkar


"Ricsec" wrote:

I have set up a spreadsheet showing charges & payments - s far I have four
pages. How does one set up the total at the bottom of page 1 to be carried
forward to the next Pages ?

Formula
 

I think I understand the question. When you print it out you have 4 pages. At
the top of each new page you would like to see the total of the previous
page. If that is true, its real simple.
Select the cell on the previous page you want to copy, right click your
mouse and select copy.
Go to the cell at the top of the page where you want to see the total, right
click and select paste special, at the bottom of the pop up select paste link.
Now whatever is in that cell will also be in this cell. This works from
worksheet to worksheet and workbook to workbook as well.

--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Ricsec" wrote:

Sorry my mistake, I meant single pages not the whole worksheet

"Elkar" wrote:

When you say "pages", do you mean worksheets? If so, then you can just
reference the cell on Sheet 1 from Sheet 2. Like this:

In a cell on Sheet 2 enter:

='Sheet 1'!A10

This will pull the value from Cell A10 on the worksheet called Sheet 1.
Change the worksheet name and cell reference to match your own.

HTH,
Elkar


"Ricsec" wrote:

I have set up a spreadsheet showing charges & payments - s far I have four
pages. How does one set up the total at the bottom of page 1 to be carried
forward to the next Pages ?