Copying cell data

[Guest]

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?

 

[Guest]

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?

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

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

 

[Guest]

Look under Edit> Paste Special> Paste Link

 

[Guest]

Look under Edit> Paste Special> Paste Link

:

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

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

[ ] = FirstSheetName!A1

Bill

 

[Guest]

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

Look under Edit> Paste Special> Paste Link

:

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

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

[ ] = FirstSheetName!A1

Bill

 

[Guest]

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

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

Bill