Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

bjett92

macrumors 6502a
Original poster
Oct 22, 2007
733
1
Indy, IN
I'm trying to create a template for notecards for our APWH class that randomly generates a page number in the chapter and a random date from the chapter. I figured out how to use the RANDBETWEEN function to generate the random number between an upper and lower value, but when I print 25 sheets, they are all the same number. Is there any way to create a random number for every sheet you print or at least generate new numbers without changing a cell value?

Thanks!

Here's a screenshot of how it looks, because I know this post is kind of confusing:
 

Attachments

  • Picture 1.png
    Picture 1.png
    15.9 KB · Views: 48
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.