Interconnected Cells (one cell on several lists)

**Amaroun** · 08-20-2014, 04:22 PM

Well I have a little bit tricky question for you guys.

Issue:
I would like to create one cell, which will be placed on several list. From another point of view, I would like to interconnect cells on several lists and make for them same rule.
For example:
You will put some value in A1 cell on list1 and it will change value in cell A1 on List2 and etc. on list3,4... But If i would like to change A1 on list2 - the result should be same. One cell on several lists.

Thx!

**aydeegee** · 08-23-2014, 11:30 AM

Hi Amaroun

Welcome to the forum.

To achieve what you are asking will require some VBA and will take a lot of upkeeping (for example if you wish to add another list)

The first part is very easy, making one cell a "master" cell (for example A1 in List 1) and reference all the other cells to that one.

I suggest that if you need to change the value while you are in (for instance List 2) then you could set up a hyperlink to List 1, amend the value in list 1 and then use another hyperlink back to List 2.

In this way you will only ever have to keep A1 in List 1 correct in order for all other values to be correct.

Let me know if I should explain anything.

Regards
Alastair

**newdoverman** · 08-23-2014, 11:52 AM

I suggest to you that you just designate LIST 1 as the master list and make all changes from there. To do what you want will create CIRCULAR references and will require VBA to get around because once you enter a value directly into one of the other lists, the formula forming the links to LIST 1 will be over-written with the value and the whole purpose of your updating will be destroyed.