I now have a workbook, where the first sheet "Bingo Draw," contains a binger caller i got from a youtube video posted by "holden McGroin" (thanks by the way and cute name). I copied the number caller 14 times as I will be facilitating 14 games at the same time, with a daily draw. I have 14 other sheets "daily tracker 1-14," that will track each individual game's progress in a format that can be easily digested. The individual sheets pull the daily number draw from the "BIngo Draw" games with a simple formula.
The first question: Is there a way to write a macro to activate the draw of all 14 games at once. I'm hoping i don't have to press all 14 games buttons each day. One button to activate the other 14 macros. I copied the code for the individual buttons, so I don't know how to create the new desire Macro.
Second question: On the "daily Tracker" sheets, I'd like to record the daily changes to cell "e19" or the daily draws, so that I know the game history. I"ve set asside columns "a" and "b" for that purpose. Iv'e already set some conditional fomatting in the lower half of the sheet to give a visual representation of all the numbers drawn during the game. Is there a formula or Macro that can be written to "record" or "log" the changes to cell "e19," where the daily bingo number gets recorded in "b" and the date it changed or was drawn put in the associated row in column "a"
the sample workbook is attached.. thanks in advance for any help.
Lots to request help with here I know
Thanks in advance
Bookmarks