copy data from sheet1 to sheet2 within a file

[rosindabow]

Hello all,

I would like to copy dat from sheet2 to sheet1 as well as some data
form sheet3 to sheet1. The data on sheet2 is a formula that reflects
the average of the 20 or so columns before it. It is expressed as a
percentage. I want to be able to work on sheet2, entering numbers,
and have only the average of those numbers show up on sheet1 (and show
up as the final percentage.) So as I add numbers on sheet2, the
average changes on both sheet2 and on sheet1. I would like to do the
same with sheet3. The object to all this is that sheet1 contains the
cumulative data from sheet2 and sheet3 and I can apply formulas to
that information on sheet1. I'm sure this is possible, but I am not
that well versed in this program and I desperately need some help. An
simple-to-undestand method out there for me to follow and learn?

Thanks very much.

 

[JE McGimpsey]

I would like to copy dat from sheet2 to sheet1 as well as some data
form sheet3 to sheet1. The data on sheet2 is a formula that reflects
the average of the 20 or so columns before it. It is expressed as a
percentage. I want to be able to work on sheet2, entering numbers,
and have only the average of those numbers show up on sheet1 (and show
up as the final percentage.) So as I add numbers on sheet2, the
average changes on both sheet2 and on sheet1. I would like to do the
same with sheet3. The object to all this is that sheet1 contains the
cumulative data from sheet2 and sheet3 and I can apply formulas to
that information on sheet1. I'm sure this is possible, but I am not
that well versed in this program and I desperately need some help. An
simple-to-undestand method out there for me to follow and learn?

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.

 

[rosindabow]

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.

That is a simple and perfect solution,,, Thanks!