bingo

Hi All, I found a video on youtube that draws bingo numbers with no repeats so I simply copied the Macro code by hand, the first part works and creates a random set of numbers the second part however is coming back with an error. This part works fine: Sub StartOver() Cells.Clear...

Hi all! This is more of a math question, but I thought I might be able to get the answer here. I would like to create a Bingo Simulator that will allow me to predict the approximate number of draws it will take to get BINGO. Bingo is typically played on a 5x5 grid, with 75 possible draws (B1...

Hi All! I have an Excel macro to print music bingo cards that does the following: Randomly chooses 25 songs from a list of x number of songs, fills in the cells of a 5x5 grid Refreshes the card, which again chooses 25 random song title to fill the card Repeats based on the quantity I choose...

Hello guys Kinda new to the forum. Ive been looking for a multiple bingo card tracker for my parents since they love playing it so much. I came across this file but do not know how to use it. Can anyone please help? TIA here is the file...

Need some help figuring out how to either make up equations or vba code to figure out 1200 combinations of 43 sets of words. What I am trying to do is merge the data into indesign on a bingo boards, 25 spaces and the center is common, so 24 boxes. I need 24 columns and each row would be made up...

Hi All! I'm really hoping someone can help me with this! I have a bingo card spreadsheet that I use for music bingo. It works like this: I paste in a list of 75 songs into sheet 1, hit F9 to refresh, and a bingo card on sheet 2 gets randomly populated with 25 of the songs. I then hit Control-P...

Hi, for a bingo game, I'm looking for a way to randomly fill a matrix of 18 rows by 9 columns with only 90 numbers (1 - 90). This means there are 72 open positions (or filled with zero's). There are some rules to be applied to fill the matrix: Each row can only have 5 numbers The first...

Hello all, Seeing if there is a way of a source range being "updated" such that once a value is selected from that source, it can not be selected again? An example being something like a bingo game where once B14 has been pulled, it is out of the pool of remaining selections? Thanks in...

At work we run a lottery bingo where 30 people pick 6 numbers each from a total of 30 numbers, the easy bit is highlighting a persons number when one is drawn using conditional formatting but I need to highlight a person if they have absolutely no chance of winning the game due to other people...