I am running a brief simulation with VBA where one variable (call it x) affects the output (call it y). The variables are two time series (x1,x2,...,x10 and y1,y2,...,y10).

I just implemeted the code to run 200 simulations at once and get the average values for x and y for each year.

What I would like to achieve in another tab is basically copying the worst case among these 200 simulations and just paste it there.

I am not sure how to proceed since the code would need to compare the results for each simulation and establish the lowest, then when finding a new lowest substituing with that, and so on.

Would anyone be able to help me?

Many thanks!