| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy data to another spreadsheet
I currently have to copy and paste data from one spreadsheet to another. Is
there a formula that I can write that would automatically copy the data that I enter in a cell on spreadsheet one to a corresponding cell on spreadsheet two. Thanks, |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy data to another spreadsheet
Hold Shift key and select Sheet2
When you type in sheet1 it also enter in sheet2 or =Sheet1!A1 "JIm" wrote: I currently have to copy and paste data from one spreadsheet to another. Is there a formula that I can write that would automatically copy the data that I enter in a cell on spreadsheet one to a corresponding cell on spreadsheet two. Thanks, |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy data to another spreadsheet
You could also link cells across sheets in this manner ..
In Sheet2, Put in B2: =IF(Sheet1!B2="","",Sheet1!B2) Copy B2 across and fill down as required to link to the corresponding range in Sheet1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "JIm" wrote: I currently have to copy and paste data from one spreadsheet to another. Is there a formula that I can write that would automatically copy the data that I enter in a cell on spreadsheet one to a corresponding cell on spreadsheet two. Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy data to another spreadsheet? see end comment | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
Linear Mode
