Good Afternoon.
I am (unsuccessfully) trying to create a sheet with the scope to convert geographic coordinates from two systems A and B A=B+X and B=A-X. I don't know from the beginning which coumun i am going to fill (sometimes A, sometimes B).
I have two columns ( A and B ) and I would like them to be blank, then when fill column B I would like column A to show B-X, and when I fill column B I would like column A to show B+X. A sort of circular reference. And to look blank until filled.
I am trying to do it with circular reference but it is not working properly, and I would like to avoid circular reference itself. Any idea (preferably not involving VBE, cz I dont master it)?
Thank you
I am (unsuccessfully) trying to create a sheet with the scope to convert geographic coordinates from two systems A and B A=B+X and B=A-X. I don't know from the beginning which coumun i am going to fill (sometimes A, sometimes B).
I have two columns ( A and B ) and I would like them to be blank, then when fill column B I would like column A to show B-X, and when I fill column B I would like column A to show B+X. A sort of circular reference. And to look blank until filled.
I am trying to do it with circular reference but it is not working properly, and I would like to avoid circular reference itself. Any idea (preferably not involving VBE, cz I dont master it)?
Thank you