I am trying to "mirror" multiple cells in a single excel worksheet. When I edit one cell, I need the others to update as well. But I want the liberty to edit any one of the cells, not just one. In other words, I need it to be multi-directional.
I did search the forum but only found references to linking either entire columns or linking cells between worksheets. I am looking to link multiple individual cells in a single worksheet.
For instance, I want the following cells linked: D71, H71, L71, D133, H133, L133, D197, H197, L197, etc.
But I also need these cells linked too: D72, H72, L72, D134, H134, L134, D198, H198, L198, etc.
I need to set up these "links" for approximately 30 different strings in the workbook.
My experience with VBA/Macros is limited. I appreciate any help you all can provide.![]()
Bookmarks