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

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