Multiple Bingo Card tracker

[kdylim]

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: https://drive.google.com/file/d/1iG56KhjKcWBjTKaqHbYMb2MdYzBgOuWY/view?usp=sharing

 

[BrianJN1]

I don't know how much this will help you, especially if you have already become aware of this.

Firstly there are quite a few columns which are hidden, they serve to map the grids which are revealed. The cells containing the words "Corners ... Full" in each circumstance are conditionally formatted and linked by formula to the right-hand adjacent cell.

Um, cells of the visible grids are also conditionally formatted too.

Now, I am assuming that Column AV, "LIST" will be the numbers drawn by the "caller", and that each card will have a selection of the numbers 1 to 75 somewhat randomly allocated to each visible grid.

As a number is entered into the LIST column its presence in any one of the grids will become highlighted in light red.

I'm assuming that the author of that sheet had in mind some on-line, or weekly game, where one might buy from 1 to 33 games.
Between purchase date and the draw you would enter your numbers into the grids. At the time of the draw you would add the drawn numbers to LIST.
If any of your numbers form one of the criteria "Corners ... Full" that specific word will be highlighted in "Yellow" indicating a win.