VBA code to change info in one cell so that other cell changes, and vice versa

I'm new to this forum, so I apologize if this topic has been previously discussed. I'm trying to figure out how to insert text or a value into a cell in one worksheet so that it translates the same information to another cell in a separate one, and if I change info in that second cell, then it updates the original. I'm not really working with any formulas- I just need to be able to link one cell so that it reciprocally updates to another. I tried messing around with circular references but from what I've gathered, I think that I need to use a VBA code. Does anyone have any suggestions or examples of how I may be able to accomplish this? Thanks so much.

For example, if I type "yes" into A1 in one worksheet, I want to connect it to another cell in another worksheet, (say B6) so that it also says "yes". Inversely, if I type "no" in B6, I would like A1 to also update to "no". I'll also be doing the same with numbers, but I'm not sure if that matters. I have two similar worksheets that I'm working back and forth in, and linking cells so that one is dependent on the other is proving to be a bit time-consuming. Thanks David!

Thank you so much! That worked perfectly. If I want to do that for multiple cells (say connect A2 to B7, A3 to B8, etc.), do I need to create a separate code for each pair? I tried it by copying and pasting one beneath the other and then modifying the references accordingly and it worked, but I'm just making sure I'm not over-looking something that would be much quicker.

Ok, cool. Thanks again, I really appreciate your help!!

Hi Tarab,

I tried this code, and it appears to be creating an infinite loop.

So when A1 changes B6 on the other sheet, the Worksheet Change executes again, and again. Is there a way to prevent this from looping?

Thanks!

Nevermind, I wrapped the code with Application.EnableEvents = False & then True before End If.

Thanks!