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

  • Thread starter Thread starter Juan Melero
  • Start date Start date
J

Juan Melero

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.
Click to expand...
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.
 
Back
Top