Cells referencing each other?

[astanix]

I was wondering if it's possible to make cells reference each other dependent upon what's typed into either of them. For example:

If someone typed 4 into A1
A1 = 4
B1 = A1 / 2

Or if someone typed 2 into B1
B1 = 2
A1 = B1 * 2

Very simplified version of something I want to do, is it possible?

[vikas.bhandari]

If you are talking about Excel Formulas, then "NO", it will create a circular reference.

Through programming, yes, but depends on your requirements. For example, I assume, you require if a user enters some value in Column A, then you need to update the corresponding cell in Column B and Vice Versa. For this purpose, I will write the code in Sheet Module :

Please Login or Register  to view this content.

hth,
Vikas

[astanix]

Thanks for the reply, I've been researching this for a while now and I came up with the following (with my error being that I don't know how to use activecell )

Please Login or Register  to view this content.

[vikas.bhandari]

Do you want to say is it resolved? If yes, then please mark it as SOLVED.

Thanks,
Vikas