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
[TABLE="width: 1325"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Advertising [/TD]
[TD="align: right"]$300.00[/TD]
[TD="align: right"]$25.00[/TD]
[TD="align: right"]$20.00[/TD]
[TD="align: right"]$15.00[/TD]
[TD="align: right"]$19.00[/TD]
[TD="align: right"]$27.00[/TD]
[TD="align: right"]$22.00[/TD]
[TD="align: right"]$45.00[/TD]
[TD="align: right"]$27.00[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$29.00[/TD]
[TD="align: right"]$18.00[/TD]
[TD="align: right"]$23.00[/TD]
[TD="align: right"]$300.00[/TD]
[/TR]
</tbody>[/TABLE]
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??