How can I make excel run like a program such that a particular cell in sheet 1 changes its value according to each successive row operation in Sheet 2. Basically I want to know if a cell can have dynamic value (act like a temporary register of "C" language which changes after execution of calculations in a row in another sheet.
It's confusing but if anyone can help me out. I am modelling something and I need this very badly to proceed further.
Let's say I am working in Sheet 1. I am working across row 1. After filling 5 columms, I want the result to go to a particular cell (Let's say A1) of Sheet 2. Now this Sheet 2 whose values change according to input at A1. This sheet 2 then again sends value to sheet1. here we work across row 2 now and the result goes to the same cell A1 of sheet 2. The point is it's a closed loop thing. and I want after every iteration, the value of particular cell changes according to the result of the iteration.