Prev: Switch lookup function to another sheet
Next: Why this formulo not working
From: nfran on 29 Jan 2010 13:58
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.
From: Gord Dibben on 29 Jan 2010 14:47
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 <nfran(a)discussions.microsoft.com>
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.

From: skane2 on 29 Jan 2010 14:59
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.
 | 
Pages: 1
Prev: Switch lookup function to another sheet
Next: Why this formulo not working