Ask Your Question
0

How can I copy a cell from sheet1 to a cell in sheet8? [closed]

asked 2014-08-27 20:39:15 +0200

tn56gent gravatar image

updated 2016-03-02 23:40:41 +0200

Alex Kemp gravatar image

Ver 3.4.5 LibreOffice

Ver Windows 7 Home Premium

Example: I have $3.50 in cell A1 of sheet1 (Gold) and I want to place that amount in cell A1 of sheet8 (Summary). This amount could change, in cell A! sheet1, and I want it to automatically update cell A1 in sheet8.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 23:40:56.822456

Comments

@karolus, you should make that an answer. Besides, if you add both dollars in the column/cell reference, it'll always stay the same when copied to another cell, which mostly isn't the desired.

rautamiekka gravatar imagerautamiekka ( 2014-08-27 21:25:27 +0200 )edit

@rautamiekka:
did somebody ask for relative references ?

karolus gravatar imagekarolus ( 2014-08-27 21:50:21 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-08-27 21:10:31 +0200

karolus gravatar image

enter =$Sheet1.$A$1 in sheet8.A1

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-08-27 20:39:15 +0200

Seen: 37 times

Last updated: Aug 27 '14