Copying cell data

T

Telavera

When I try to copy date from a cell on one sheet to a cell on another in 2002
using copy and paste I cannot get the cells linked because I can't locate the
'Link cells' command. Where is it?
 
G

Guest

Telavera said:
When I try to copy date from a cell on one sheet to a cell on another in 2002
using copy and paste I cannot get the cells linked because I can't locate the
'Link cells' command. Where is it?
Click to expand...

----------------

I don't quite understand what you're trying to do with copy/paste. From
what I *mis*understand, I would think you would just put on the second
sheet something on the order of:

[ ] = FirstSheetName!A1

Is this what you need, or something more complex and wonderful?

Good luck....

Bill
 
G

Guest

Duke said:
Look under Edit> Paste Special> Paste Link

:
Click to expand...

-----------------------------------------------------------

And, I would point out, all that does is to create the cell contents:

[ ] = FirstSheetName!A1

Bill
 
D

Duke Carey

And, I concede that point, but if the OP wants to know how to find the Paste
Link feature...

Bill Martin -- (Remove NOSPAM from addre said:
Duke said:
Look under Edit> Paste Special> Paste Link

:
Click to expand...

-----------------------------------------------------------

And, I would point out, all that does is to create the cell contents:

[ ] = FirstSheetName!A1

Bill
Click to expand...
 
G

Guest

Duke said:
And, I concede that point, but if the OP wants to know how to find the Paste
Link feature...
Click to expand...

You're absolutely right Duke. I just meant to point out to the OP what
that function actually does under the covers.

Bill
 
Top