I love a challenge…

Steve asked if anyone could help with a little excel project he was working on and I’ve had a go and the result can be downloaded here.

I copied the original sheet into a new sheet and recorded a quick macro that copied the random numbers from one sheet and then pasted them as values in the next.  I also added a little conditional formatting for the incorrect/correct statements.  I think it works OK but if you change the sheet names you will need to change the macro as well.