Put this in B10 through B17
=IF($A$1<"",$A$1,"")
( it will read the number in A1)

Put this in C10
=IF(A2<"",A2,"")
( it will read the number in A2)

Put this in wherever you need
=SMALL(D10:D15,1)
(It will give you the smallest number between D10 and D15)
Im not sure if you need to parse D10 for the smallest number, if you have
more than one number in D10......, but I thought that might just be a typo
there.
HTH


Put this in C11
=IF(A3<"",A3,"")
( it will rrad the number in A3)

Put this in C12
=IF(A4<"",A4,"")
( it will rrad the number in A4)






"cfman" wrote:

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!