I am working with one excel workbook. I have 2 sheets in the work book. I want the informatioin I have in one worksheet to be copied into the 2nd worksheet as I enter the data. Example: I have an averaged number in cell B58 on worksheet 1. I want the same number to be transferred into cell C31 of the 2nd worksheet. Anyhelp would be great! Thanks in advance.
2006-12-15 02:41:07 · 2 answers · asked by Heath 1 in Computers & Internet ➔ Software
ok very simply do the following :
go to sheet 2, to cell C31 and type this : =Sheet1!B58
This should do the trick ;)
good luck
2006-12-15 03:05:08 · answer #1 · answered by KickBoxer 3 · 0⤊ 0⤋
=+Sheet1!B58
Put this in C31 of worksheet 2
Or you can click in the C31 cell, enter the '+' sign, and then go back to sheet 1 and click on cell B58, then hit 'enter'.
2006-12-15 03:00:24 · answer #2 · answered by strunbike 2 · 0⤊ 0⤋