Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frank JC
 
Posts: n/a
Default 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?
  #2   Report Post  
Ralph Howarth
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional summing with large amounts of data Revontulet Excel Worksheet Functions 1 January 26th 05 08:13 PM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"