For the random number generator, you can place
Code:
=Rand()*(b-a)+a
in a field where b is the largest number you want to generate and a is the smallest. If you want to make it an integer, use
Code:
int(expression)
so =int(Rand()*(b-a)+a)
You could then record a macro to recalculate this field by pressing f9 (i think?)
Set this macro to a button and bam