Macro or Eqn to Repeat Formula "X" times based on Number in Cell

Hi Guys,

I'm looking to randomly generate a series of values based on set bounds and a desired number of generated values. I know you can drag the right hand corner to apply a forumla but I would really like excel to autofill the rows for me.

I have a lower bound (A5), upper bound (B5), and number of loans (A7). I can randomly generate the first value using =RANDBETWEEN($A$5,$B$5). Now based on the number in (A7) I would like excel to repeat the formula the specific number of times and then autofill the values in the appropriate rows. I've attached the workbook to the body of the this thread. Thanks a lot for the help!

Andrew

Hi,

Formula:

Please Login or Register  to view this content.

Ovidiu

Hi,

If you want to fill all the columns, then you below:

Formula:

Please Login or Register  to view this content.