Populating Values in Excel via VBA or Excel function

[kman]

Is there a way in excel or using VBA that I can perform the following.

If the number 20 is in cell A5 I want all the values in cell A1-A4 to be populated with values that will total to 20.

If the number 100 is in cell A10 I want all the values in cell A1-A9 to be populated with values that will total to 100.

Can this be done? If so please provide example.

Thanks

 

[Richard Schollar]

Hi

It can be done very easily as long as you accept that the values (eg in A1-A9) in each cell will be the simple total divided by the number of cells (so in the case above 100/9 = 11.111 in each cell).

Can you elaborate a little further as to exactly what numbers you require?

Thanks.

Richard