ExcelBanter - Copy and Paste from One SS to Another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy and Paste from One SS to Another (https://www.excelbanter.com/excel-worksheet-functions/254822-copy-paste-one-ss-another.html)

nfran

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.

Gord Dibben

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.

skane2

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.

All times are GMT +1. The time now is 03:15 PM.