I have two arrays of numbers (see attached file). I want to setup the worksheet so that I can link the movement of cells in the first array (B2:K:11) with the corresponding cells in second array (B13:K22). For example, if I was to swap cells C2 with F11 I would like cells C13 and F22 also to swap automatically. I would like this process to be automatic because in the future I will have several arrays all of which I would like to link the movement to one master array.
Many thanks in advance for your help.
Bookmarks