is there a way to program my Excel file to do a loop?
 

Hi all,

If I want B10 to B17 all follow the change of the same number(copy cell),
let's say I put it in A1,

and C10 follows the change of A2(copy cell), and C11 follows the change of
A3(copy cell), and C12 follows the change of A4(copy cell),

then I have 4 variables in my calculations: A1, A2, A3, A4.

I want to loop each of the variables in a different set,

then I hope the whole worksheet will be able to refresh following the change
of A1, A2, A3, A4,

and then I want to find the very set of A1, A2, A3, A4 that gives the
smallest value of D10,

how do I program the whole procedure in Excel?

Please give me detailed program, I am really a newbie in Excel, I tend to
learn better with hands-on problem and sample detailed answers.

Thanks a lot and happy near year!