How to duplicate one cell to a different sheet

[Gabrielle_erre]

Hi, I'm Gabrielle and I'm new on the website. I have the following question :

A2 [text-1] in sheet 1
D1 [='sheet1!A1] in sheet 2

I can duplicate and/or use exact cell(with value or text) from A2 (Sheet1) and have it in D1 (Sheet2)? The format of the cell is standard.

If I write in D1 =sheet1'!A2 it's only showing me the function in the cell =sheet1'!A2 and not the text I need.

*additional question: is it possible in excel to "clone" one cell? In the given example, if I'll modify the value/text also from D1 manually to automatically update it also in A2?
Thanks in advance!

 

[MARK858]

What happens with

='Sheet1'!A1

or

=Sheet1!A1

The form General?at of the cell is standard.Do you mean it is formatted as General?

Also is your calculation set to manual or automatic?

 

[MARK858]

I don't know what happened in the last post, the gobbledygook part should read as....

The format of the cell is standard.

Do you mean it is formatted as General?