Copy data
 

I have made up a spreadsheet that has 17 worksheets ,I need to copy data
from one worksheet to the next EG
Worksheet 1 column B cell 23 to worksheet 2 column B cell 2.
Can anyone please tell me what I need to write for the equation??

Thanks
JOHN




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000774-7, 15/09/2007
Tested on: 21/12/2007 3:45:52 PM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com

Copy data
 

in cell B2 worksheet2 you can put:
=worksheet1!B23

change worksheet1 to whatever name you have for your worksheet.

hth
Carlo

On Dec 21, 1:45*pm, "Atty" wrote:
I have made up a spreadsheet that has 17 worksheets ,I need to copy data
from one worksheet to the next EG
Worksheet 1 column B cell 23 to worksheet 2 column B cell 2.
Can anyone please tell me what I need to write for the equation??

Thanks
JOHN

---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000774-7, 15/09/2007
Tested on: 21/12/2007 3:45:52 PM
avast! - copyright (c) 1988-2007 ALWIL Software.http://www.avast.com