Hello,
I have the following question:
I need to make a direct link between two cells in two different files. In other words: Both cells have to display the value that is inserted the last in either of the cells. So lets say we have file A and file B.
Someone opens file A, changes the value of Cell A1 and closes the file again. After that someone else opens file B. Cell A1 of file B has to be the same value as A1 of A.
But vice versa it needs to be the same.
So if someone changes A1 of B again, A1 of A has to change with it.
So it's not just a "=" formula.
I know it has to be done in VBA, but i'm a total noob in VBA. Anyone here that can give me a push in the right direction?
Thank you in advance.
I have the following question:
I need to make a direct link between two cells in two different files. In other words: Both cells have to display the value that is inserted the last in either of the cells. So lets say we have file A and file B.
Someone opens file A, changes the value of Cell A1 and closes the file again. After that someone else opens file B. Cell A1 of file B has to be the same value as A1 of A.
But vice versa it needs to be the same.
So if someone changes A1 of B again, A1 of A has to change with it.
So it's not just a "=" formula.
I know it has to be done in VBA, but i'm a total noob in VBA. Anyone here that can give me a push in the right direction?
Thank you in advance.
