How to use the data in a row as a input and as well as Output using MAcro

[Shasun]

Hello guys

I'm looking for a macro program to use the data in a row as an input to the next row calculations and as well as output from the previous row.

Example:
Column A B C D E F
Row 1 : A1 B1 C1 D1 E1 F1
Row 2 : A2 B2 C2 D2 E2 F2
Row3 : A3 B3 C3 D3 E3 F3
.
.
.
RowN : AN BN CN DN EN FN

In the first row , the user will enter the values manually (it is fixed one). In the next row, I use formulas and some conditions to check the values for Row1 and calculate the output and display it in Row2. Then, I wanna use the row2 output as input to Row3 and need to calculate the output using the above specified formulas. I need to repeat this step until the end of the rows or until to satisfy my conditions.

I'm newbie in macro programming, so looking for any assistance to complete this work.

Thanks