Copy and Paste from One SS to Another

N

nfran

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.
 
G

Gord Dibben

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
 
S

skane2

If your data has formulas it will not copy and paste correctly. Try copying
and paste special and choose value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Copy and Paste in Excel 2003 0
concatenate will not paste special 3
Count the columns from one sheet and paste it in another sheet 0
Copy formulas from one workbook to another 1
want to track time while paste value in multiple column of same roe 1
Cannot paste column data from one worksheet to another 2
Copy Paste in Excel 2007 3
Copy Paste to another sheet 2

Top