VBA Code to use output of 1st iteration in 2nd iteration till reaching optimum solution

[YasminHakim]

Hi all,

I am trying to do genetic algorithm in excel and the 1st trail will result in a recommendation by saying replace parent 1 by child 2 for example.

the question is how can i code that in excel, so it will replace parent 1 by child 2 and do another iteration etc, till i reach a number of iterations=100 for example or till reaching a stopping criteria.

Thank you in advance