| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy and Paste from One SS to Another
I am trying to copy and paste some data from one spread sheet to another
(both Excel 2007). The cells ,where info supposed to land, show as selected, but no data displayed. Any suggestions aprriciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy and Paste from One SS to Another
Is this a manual copy/paste operation?
i.e. copy A1:G12 from book1 switch to book2, select a single cell and paste? Do you have both workbooks open together? Are they in same instance of Excel? Gord Dibben MS Excel MVP On Fri, 29 Jan 2010 10:58:01 -0800, nfran wrote: I am trying to copy and paste some data from one spread sheet to another (both Excel 2007). The cells ,where info supposed to land, show as selected, but no data displayed. Any suggestions aprriciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy and Paste from One SS to Another
If your data has formulas it will not copy and paste correctly. Try copying
and paste special and choose value. "nfran" wrote: I am trying to copy and paste some data from one spread sheet to another (both Excel 2007). The cells ,where info supposed to land, show as selected, but no data displayed. Any suggestions aprriciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Linear Mode
