Ask Your Question

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

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

tn56gent gravatar image

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

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


@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 +0100 )edit

did somebody ask for relative references ?

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

1 Answer

Sort by » oldest newest most voted

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

karolus gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 36 times

Last updated: Aug 27 '14