I need someone to create a macro that randomizes some numbers for me
Budget: $10 – $30 USD
The sheet and instructions on the excel document are already ready to go. I'm just looking for someone who can turn this into a macro that will allow me to randomize an outcome over and over.
I need a macro built that allows for a button to be clicked in A1 which randomizes the values for B2 - B7 so that the highest possible number is .5 and that all values must add up to exactly 1. It should also randomize G1 to be a value between .8 and .8999 It should also randomize E19 to be a value between .4000 and .4499
I need a macro built that allows for a button to be clicked in A1 which randomizes the values for B2 - B7 so that the highest possible number is .5 and that all values must add up to exactly 1. It should also randomize G1 to be a value between .8 and .8999 It should also randomize E19 to be a value between .4000 and .4499