Divide money amount randomly by 12

[dilbert72]

Hello All I need a macro to take a yearly total and divide it by 12 but with a random number for each month.

Thank You

For example

 

[Jubjab]

your question is not clear. Could you give an example of how the source data looks like as well as the desired result.

 

[JLeno]

In A1:A12, put

=RAND()

In B1:B12, put

=A1 / SUM($A$1:$A$12)

Multiply the annual total with the numbers in B1:B12 (which add up to 1, or 100%), and your total is randomly divided over 12 months

 

[dilbert72]

your question is not clear. Could you give an example of how the source data looks like as well as the desired result.

The data should look like

Advertising

$300.00

$25.00

$20.00

$15.00

$19.00

$27.00

$22.00

$45.00

$27.00

$30.00

$29.00

$18.00

$23.00

$300.00

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

Total

 

[Jubjab]

Thanks, but it seems JLeno already gave a good answer.

 

[dilbert72]

Is it possible to put in a floor and ceiling??

This is going to require to lines for each amount??