Iteration loop for the excel tables

Originally Posted by Crooza

Hi and welcome.

It looks like you're using a neural network. If you just want to iterate and not repeat all the tables below line 110 use this (it uses a macro to copy the data from the tables back up to the top weights and start again). I've got it copying the S0 and S1 values each iteration into columns U and W and I've put your calculated S0 values into column V just to compare the results. I've set it to do 20 iterations but you can change the macro to as many as you want.

Yes, Thank you very much for your code. That 's great and all I need, but could you help me do it more completely? How to clear data to start the new iteration? and add a cell to define a n times iteration.
Thank you very much again.

Originally Posted by Crooza

Try this. it clears the old data in columns T, U and W.. Set cell H4 to the number of iterations you want

Yes, that 's wonderful. I very thank you for help. That' s all I need.
Have a nice day friend,