Circular Reference problem...!

[avinashraste]

Hello Friends,

I am facing a very peculiar circular reference issue. I have a sheet where my requirement is if I put "abc" in the cell A1, the cell C1 show "abc". The problem arises when I want to show the same wise versa, i.e. if I write "abc" in cell C1 first, then cell A1 also should show the same.

so, in a way, where ever I write first, whether in cell A1 or cell C1, the other one should reflect the same...!!! Please guide & help.

Thanks & Regards

AR

 

[mole999]

because A1 =C1 and C1 =A1 you will get the circular reference, you can often detune the iterations used for calculation, better to use VBA to monitor A1 and C1 and then copy the value without formula, though with those two cells so close together I do wonder why you could input in either