Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying cell data
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? -- Telavera |
#2
|
|||
|
|||
Telavera wrote:
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 |
#3
|
|||
|
|||
Look under Edit Paste Special Paste Link
"Telavera" wrote: 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? -- Telavera |
#4
|
|||
|
|||
Duke Carey wrote:
Look under Edit Paste Special Paste Link "Telavera" wrote: 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? -- Telavera ----------------------------------------------------------- And, I would point out, all that does is to create the cell contents: [ ] = FirstSheetName!A1 Bill |
#5
|
|||
|
|||
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" wrote: Duke Carey wrote: Look under Edit Paste Special Paste Link "Telavera" wrote: 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? -- Telavera ----------------------------------------------------------- And, I would point out, all that does is to create the cell contents: [ ] = FirstSheetName!A1 Bill |
#6
|
|||
|
|||
Duke Carey wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Formula for copying data for every 8th cell | Setting up and Configuration of Excel | |||
GET.CELL | Excel Worksheet Functions |