Is there a way to print a sheet in excel several times (for my purposes I need to print it out 50 times), and have the random sequence in my sheet be different for each copy? I'm using this to make bingo cards, but I don't want to copy and paste the bingo grid in excel 50 times. Ideally, I'd only have one random bingo grid in my sheet, and print 50 copies where the random number generation in the grid is different for each copy.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you for the resource - unfortunately this doesn't solve my problem. I'm making custom bingo cards with song titles on them (not numbers), so I've created the random grids myself in an excel sheet.
If you have Excel 365:
This formula returns 50 bingo cards with on each bingo card 5*5 (25) different random numbers between 1 and 75:
Formula:
Please Login or Register to view this content.
You could create each bingo card as a PDF file and print: much easier to give a reply if you posted a sample workbook so see yellow banner at top of page on how to attach a workbook.
bingo cards with song titles please try:This formula creates 50 random bingo cards with song titles. This formula assumes there are 80 different songs and 25 songs on each bingo card.Formula:Please Login or Register to view this content.
If you want the same songs on each bingo card in a random order on each bingo card, please replace K1:K80 with K1:K25.
Last edited by HansDouwe; 10-31-2023 at 01:32 PM.
For correct printing the random bingo cards,
please
insert page breaks or
adjust the top/bottom margins or
adjust the hight of the empty rows
so it fits.
Last edited by HansDouwe; 10-31-2023 at 02:06 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks