Trying to Link Circular Data Between Multiple Cells

[swordswinger710]

Hey,

This one has me scratching my head. I have a fairly large workbook with many sheets. Some of these sheets contain data in certain cells which correspond to other cells in other sheets. These 'groups' of cells must always display the same information, at all times, and whenever the data in one of the cells in the group changes, all the rest must be updated to read the same. For example:

Group 1 consists of Cell A1 on Sheet1, Cell B2 on Sheet 2, and Cell C3 on Sheet 3.

So, if Cell A1 on Sheet 1 contains 'Blah Blah 88', so does Cell B2 on Sheet 2, and Cell C3 on Sheet 3.

If I click on Cell C3 on Sheet 3 and change it to read 'Whatever 93', then Cell A1 on Sheet 1 on Cell B2 on Sheet 2 should display 'Whatever 93'.

I'm able to do something similar to this by linking the cells, but it only works one way. I get a circular reference error upon trying to link two to each other so it works both ways. Is there a formula, perhaps one I can enter using validation or something to make this work? Or does this work at all?

[swordswinger710]

Does anybody here have any idea as to what I'm talking about?

[jaslake]

Place this code in Sheet1 Module

Please Login or Register  to view this content.

Place this code in Sheet2 Module

Please Login or Register  to view this content.

Place this code in Sheet3 Module

Please Login or Register  to view this content.

[swordswinger710]

So would code be the only way to do this? I see this is definitely an option, I'm just asking if there is any other way, as I have as many as ten cells throughout my workbook that must all be linked together, and as many as fifty cells on a single sheet that are linked to other sheets.

About the code though, it works great, thank you so much! The only issue I've noticed is that when I erase the data in one of the cells, the other two still display the previous information and aren't cleared. It would be awesome if they would clear as well.

[jaslake]

Hi swordswinger710
To do this

The only issue I've noticed is that when I erase the data in one of the cells, the other two still display the previous information and aren't cleared. It would be awesome if they would clear as well.

In each procedure, change this line of code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Adding other linked cells is not an issue...you'll want to research "Select Case" perhaps.
There may well be other ways of doing this but none with which I'm familiar.