Problem which requires looping back and forth between 2 sheets of a workbook

Hi dears

I am a beginner in VBA and I am asking for your kind help

I have two sheets of a workbook in excel with a following problem:

In the first sheet "input-output" I have 3 input variables in 3 columns (input1, input2, input3, each has 200 rows) and 2 output variables (output1, output2, each has to be filled with 200 results). The three inputs must be copied into the second sheet, which is a "blackbox" type of sheet, with about 30 formulas which yield 2 output variables. These 2 must be copied back into the two output columns.

This has to be repeated 200 times (looped, I suppose) till all output values have been filled. This must some sort of loop which goes back and forth between the 2 sheets. In the "input-output" sheet input and output cells are at same corresponding heights (rows), whereas in the "blackbox" sheet, 3 inputs and 2 outputs are at fixed cells.

Can someone write out the code? Thanks in advance

Hi Nepremostivi & welcome to the forum,

You would get better responses if you attach file with the current layout of your data structure & the expected results (do few rows manually). Just follow the instructions in the yellow banner at the top of the page on how to attach an excel file

dear nankw83

Thanks for the instruction. Sample excel file attached.

(removed as too late)