crossed two cells

[berner3]

hello
I need. crossed two cells.
Thus, if the change will "A1" to 3 thus change the "G5" Also at 3, and similarly, change the "G5" to 2 equally changes "A1" to 2
thanks

[shg]

Welcome to the board.

That can't be done without VBA.

[FDibbins]

Hi, welcome to the forum

If I understand you correctly, you want to have A1 change to what G5 contains, and also have G5 change to what A1 contains.

If this is what you want, it cannot be done with formulas.
1st A cell can contain either a formula (in A1 to reference what G5 contains) OR a value, not both
2nd, if you DID put a formula in both cells, referencing each other, you would create a circular error - never a good thing to have

the only other option would be VBA (program coding)