Forum Discussion

Copper Contributor

Feb 22, 2022

Solved

Random number generation

Hi everyone. I have been working on a formula that uses inputs that have been generated randomly (through RANDBETWEEN) to get to the result of this formula. Obviously, given that the inputs are rando...

excel

Formulas and Functions

cris_22
Feb 23, 2022
MS99MS if you are familiar with macros, here's one you can incorporate. If you are not, you can have 1000 RAND formulas, hitF9 to generate values, than copy and paste values only in another file/sheet

cris_22

Brass Contributor

Feb 22, 2022

you could create a small macro to copy/paste (values only) in another tab. maybe introduce a today() formula in the originating s/s and your result s/s would have a column for all dates and use a lookup of the date to update the value each time they are opened. I think you would need to open both s/s.

MS99MS

Copper Contributor

Feb 22, 2022

Thank you for your reply cris_22

How do I create the small macro to copy/paste (values only) in another tab?

cris_22
Brass Contributor
Feb 23, 2022
MS99MS if you are familiar with macros, here's one you can incorporate. If you are not, you can have 1000 RAND formulas, hitF9 to generate values, than copy and paste values only in another file/sheet
- mtarler
  Silver Contributor
  Feb 23, 2022
  alternatively if you have Excel365 you can just use RANDARRAY() and choose #row, #col, min, max and if it should be integers.
  - cris_22
    Brass Contributor
    Feb 23, 2022
    mtarler OK, have to say that's really cool. Nice!