Hello excel user

If Sheet1 = Sheet2 and vice versa, all cells containt a formula : If
somebody enter a value, he scratche the formule

This is correct, if the option Excel Iteration is active with 1 itération

But if somebody enter a value if sheet1!C5, he does nots enter another value
in Sheet2!C5 : because in this cause Sheet1 is not same Sheet2

I hope inderstand your trouble

J a c q u e s

"excel user" <excel a écrit dans le message
de ...
Hi All,
I am trying to find out if circular scripting is possible in excel and how
easily. We are trying to create a "web downloadable" excel with multiple
sheets and the idea is to have circular sripting between atleast 2 sheets
i.e. f somebody enters a value in a cell in sheet 1, it should be auto
populated in sheet 2 in a cell that refers to the cell in the first sheet
and
vice versa. One way communication seems to be fairly easy. Where we are
running into trouble is having the 2 way communication i.e. 1=2 and 2=1.