close

I have set up a spreadsheet showing charges amp; 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 quot;pagesquot;, 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,
Elkarquot;Ricsecquot; wrote:

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

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

quot;Elkarquot; wrote:

gt; When you say quot;pagesquot;, do you mean worksheets? If so, then you can just
gt; reference the cell on Sheet 1 from Sheet 2. Like this:
gt;
gt; In a cell on Sheet 2 enter:
gt;
gt; ='Sheet 1'!A10
gt;
gt; This will pull the value from Cell A10 on the worksheet called Sheet 1.
gt; Change the worksheet name and cell reference to match your own.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Ricsecquot; wrote:
gt;
gt; gt; I have set up a spreadsheet showing charges amp; payments - s far I have four
gt; gt; pages. How does one set up the total at the bottom of page 1 to be carried
gt; gt; forward to the next Pages ?

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.quot;Ricsecquot; wrote:

gt; Sorry my mistake, I meant single pages not the whole worksheet
gt;
gt; quot;Elkarquot; wrote:
gt;
gt; gt; When you say quot;pagesquot;, do you mean worksheets? If so, then you can just
gt; gt; reference the cell on Sheet 1 from Sheet 2. Like this:
gt; gt;
gt; gt; In a cell on Sheet 2 enter:
gt; gt;
gt; gt; ='Sheet 1'!A10
gt; gt;
gt; gt; This will pull the value from Cell A10 on the worksheet called Sheet 1.
gt; gt; Change the worksheet name and cell reference to match your own.
gt; gt;
gt; gt; HTH,
gt; gt; Elkar
gt; gt;
gt; gt;
gt; gt; quot;Ricsecquot; wrote:
gt; gt;
gt; gt; gt; I have set up a spreadsheet showing charges amp; payments - s far I have four
gt; gt; gt; pages. How does one set up the total at the bottom of page 1 to be carried
gt; gt; gt; forward to the next Pages ?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()