Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
copy data from sheet1 to sheet2 within a file
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="JE McGimpsey, post: 6799179"] One way: Assume you're entering your data in Sheet2, cells A1:A20, and that the average formula is in cell A21: =AVERAGE(A1:A20) Then in, say, Sheet1, cell J5, you can enter =Sheet2!A21 to link the Sheet2 average to the Sheet1 cell. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
copy data from sheet1 to sheet2 within a file
Top
