How read and calculate data from one worksheet to another?

[Frank JC]

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?

 

[Ralph Howarth]

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!