Hi folks.
I wish to create discreet two-way links between two ranges of cells in the same sheet. Range 1 is A41:A56 and Range 2 is A61:A76. I would like to create a situation in which whenever A41 is changed, it also changes A61, and vice versa. Ditto for A42 changing and changed by A57...and so on. I've tried a variety of methods using worksheet_change, but am having trouble getting the bi-directionality to work. Also, when I change any of the A41-A56 cells, it produces the same change in the entire Range 2 group, rather than the single cell that is its counterpart. Any help with this would be greatly appreciated.