How to put value in cell in Sheet 1 into cell in Sheet2

Does anybody know a way of getting the value of a cell in
Sheet 1 of Workbook 1 into a cell in Sheet 2 of Workbook 1
without writting code. If there is no way to do it
without code can someone please give me some clues on how
to write the code.
Example
Cell A10 in sheet 1 holds the Average of cells A1:A9. I
want to put the value of cell A10 in Sheet 1 into Cell A1
in Sheet 2. All this is in the same workbook.

in cell A1 sheet two type

=Sheet1!A10

Randall


On Tue, 2 Dec 2003 09:45:54 -0800, "Juan Melero"
wrote:

Does anybody know a way of getting the value of a cell in
Sheet 1 of Workbook 1 into a cell in Sheet 2 of Workbook 1
without writting code. If there is no way to do it
without code can someone please give me some clues on how
to write the code.
Example
Cell A10 in sheet 1 holds the Average of cells A1:A9. I
want to put the value of cell A10 in Sheet 1 into Cell A1
in Sheet 2. All this is in the same workbook.

Thanks. Worked like a charm.
-----Original Message-----
in cell A1 sheet two type

=Sheet1!A10

Randall


On Tue, 2 Dec 2003 09:45:54 -0800, "Juan Melero"
wrote:

Does anybody know a way of getting the value of a cell
in
Sheet 1 of Workbook 1 into a cell in Sheet 2 of Workbook
1
without writting code. If there is no way to do it
without code can someone please give me some clues on
how
to write the code.
Example
Cell A10 in sheet 1 holds the Average of cells A1:A9. I
want to put the value of cell A10 in Sheet 1 into Cell
A1
in Sheet 2. All this is in the same workbook.

.

-----Original Message-----
Does anybody know a way of getting the value of a cell in
Sheet 1 of Workbook 1 into a cell in Sheet 2 of Workbook
1
without writting code. If there is no way to do it
without code can someone please give me some clues on how
to write the code.
Example
Cell A10 in sheet 1 holds the Average of cells A1:A9. I
want to put the value of cell A10 in Sheet 1 into Cell A1
in Sheet 2. All this is in the same workbook.
.
Go to sheet 2, select the cell you want: in your case A1.
Type "=", then mouse to sheet1, select cell A10 (or
whatever you want to use), then hit Enter. If you want to
be able to add rows to the 1-through-9 grouping, you're
done. If you want sheet 2 cell A1 to always refer to sheet
1 A10, then tap the F4 function key before hitting Enter.
That locks the reference to that cell, no matter what else
you do to sheet1. Try it in a new blank workbook first -
it's easy.