Forum Discussion
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...
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.
Thank you for your reply cris_22
How do I create the small macro to copy/paste (values only) in another tab?
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
- alternatively if you have Excel365 you can just use RANDARRAY() and choose #row, #col, min, max and if it should be integers.
