Random Numbers (predefined range)

[ragnadok]

Hello.
I'm a newbie to excel and was wondering if I can get some help changing my excel formula to a VBA macro for my workbook as the randbetween function in excel recalculates all my numbers each time the workbook is updated.
I've attached my project, the orange (height)columns is where I need the randoms numbers to be generated.
Any help would be super appreciated.
Thank you!

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. AFAIK there is no XL2014
Thanks

[Kaper]

Hope the above administrative note does not block the possibility to give some insight. But please before you answer below question, do follow the administrator request.

What are the rules to set random between limits. In most of cells you have RANDBETWEEN(5, 6) but for instance in whole row 3 the limits are 5 to 7, in row 4 limits are 6 to 8 (but cell E4 where it's between 7 and 8). etc.

[davsth]

You could do a macro if you really needed

I would put the below formula some where and then past into cell d2 as text and copy down and across
=IF($C2>=COLUMN(A1), RANDBETWEEN(5, 6),"")

then copy and paste as values on top of the data to make it static


if you really wanted a macro

Please Login or Register  to view this content.

[ragnadok]

Hi.
I updated my profile as requested. Thanks for the tip.

[ragnadok]

Hello.
I'm still working on the workbook. The column "quantity" is where I would put how many cells would be filled under the "heights" column. The random number range would probably go up in threes ie; circumference of 6 would generate numbers between 5-7, 8: 6-9, 10:8-11, 12:10-12 and so on.

[ragnadok]

Hi.
Really appreciate your help. Just that if I run your macro all cells under height gets filled with all 5 or 6 and not randomly. Also column 'quantity is there to tell how many cells should be filled the heights columns. For example if quantity is 3 then only 3 cells would be filled with random numbers if quantity is 24 the all 6 cells in column heights would be filled. Hope you understand my question. Thank you again for your help.