Calc: Cell content auto copy

Hi!
I just want to have the content of a cell automatically copied into another cell(s).
And when I change the content of the mother cellthe respective ‘slave(s)’ should change too.

Say you want the content of A1 repeated in C1; in C1 use the formula =A1 If you modify A1 the change will be reflected in C1.

If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. That will help other people with the same question.

In case you need clarification, edit your question (don’t use an answer) or comment the relevant answer.

image description