Linking two sheets without source sheet (bi-directional linking of sheets)

[ElliPelli92]

Hi all,

I am new here, but couldn't find the answer in previous posts. Feel free to send a link to an old post solving this issue if you know of one! Now to my problem.

I want to link two worksheets in the same document, whereby if changes occur in A, the changes should also be entered in B and if changes are made in B these should also be visible in A. Linking unidirectional, using A as source and B as target, is easy, but I am not sure how to solve the issue of making it bi-directional. Logically this would result in a circular error, but I am hoping there is a way to get around this using a VBA macro.

The changes mostly relate to adding a row in between existing rows and adding a few bit of information. into the first 8 columns. At the moment, if I insert the row and add the info in A they also occur in B (simple), but when I add rows in B and add the info it does nothing in A.

Does someone have a code or could tell me how to start this code to prevent the circular error?

Many thanks!