In this video, I show how to use the randbetween function to generate random integers between two values. While this is useful, excel will keep changing these numbers every time you alter something on your worksheet. To fix this, I show how you should copy and paste your randomly generated numbers to turn them into fixed values which will not change.