| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use Copy and Paste
Hello,
I have two spreadsheets. test1.xls, test2.xls test2.xls sheet1 A1=[test1.xls]Sheet1!$A$1 When I use copy and paste to B1,C1... I got B1=[test1.xls]Sheet1!$A$1 C1=[test1.xls]Sheet1!$A$1... If sheet1 A1=Sheet2!A1 then I use copy and paste to B1,C1...(same spreadsheet) I got B1=Sheet2!B1 C1=Sheet2!C1 How can I make the first one work? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use Copy and Paste
hi.
confused. how do yo want it to work?????? i think all you have to do is remove the $ from the first. it the difference from absolute reference and relative reference. absolute reference (with $) don't change when you copy and paste relative reference (without $) changes. Regards FSt1 "Newbie" wrote: Hello, I have two spreadsheets. test1.xls, test2.xls test2.xls sheet1 A1=[test1.xls]Sheet1!$A$1 When I use copy and paste to B1,C1... I got B1=[test1.xls]Sheet1!$A$1 C1=[test1.xls]Sheet1!$A$1... If sheet1 A1=Sheet2!A1 then I use copy and paste to B1,C1...(same spreadsheet) I got B1=Sheet2!B1 C1=Sheet2!C1 How can I make the first one work? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Linear Mode
