| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
| Copy data into cells until changes trigger new copy | Excel Programming | |||
Linear Mode
