Excel linking cells

[Hidden999]

Hi guys,

I am making a worksheet and have a question regarding linking cells.

What I want to achieve:
Having two cells (on different sheets or not) which contain the same text.
So if I change the text in one cell it also changes in the other cell. Vice versa.
I've tried doing it just like this.

A1 contains formula (=B1)
B1 contains formula (=A1)

But then if you type it overwrites the formula.

Thanks in advance!

 

[Fluff]

What does it say in Dutch?
Also you are missing an l in Value

 

[Hidden999]

My bet, I forgot to change the ranges above. It works now!! You have a lot of patience which I really admire haha.

 

[Fluff]

Glad it's working & thanks for the feedback