Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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
 
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.
 
Back
Top