How read and calculate data from one worksheet to another?
 

I have set up an account book so that Page 1 is January, Page 2, February and
so on. I wish to transfer the final row of data from page 1, [eg line 58] to
line 5 on page 2. Ids it possible to do this? or can I only transfer a cell.
If so, how do I go about it?

Frank,

Yes can do.

1) Go to Page 2 and click-drag over the range of target cells that comprise
the line 58 of the Page 1 worksheet (I presume is a worksheet...)
2) Let go of the mouse and type in an equal sign "=".
3) Move your mouse over the Page 1 and click-select page one to become the
active sheet.
4) Click-drag the range of cells of Line 58.
5) Hit Cntrl+Enter.
6) Stand up and cut the rug.
7) repeat the process for the remaining months by carrying the range of the
prior worksheet over like we just did.
8) Enjoy!

"Frank JC" wrote:

I have set up an account book so that Page 1 is January, Page 2, February and
so on. I wish to transfer the final row of data from page 1, [eg line 58] to
line 5 on page 2. Ids it possible to do this? or can I only transfer a cell.
If so, how do I go about it?