|The old version of the Super Bowl Squares template|
I’ve had an idea for streamlining and improving the grid game spreadsheet for over two years but just finally had enough time and energy to work on it before the actual Super Bowl. It’s taken many hours of work setting up the macros and testing all of the conditions but it’s finally ready: the new and improved Super Bowl Squares template is here!
When you first open the template you’ll notice the big changes right off the bat. You’re met with a simple setup screen where the user will decide how to play the game. The sheet automatically updates the Super Bowl boxes and the leaderboard to reflect only the version of the game you want to play.
I used to have to update the sheet every year by inputting the teams and their helmets. This time, all the teams and helmets are in one of the sheets. Simply use the drop down lists in the Squares sheet to select the team from the list (broken up by AFC and NFC) and their helmets will update automatically!
Even if you’re not into football, you can still use the template to learn how to do these Excel tricks:
- Lookup pictures based on cell values
- Generate random numbers
- Use NameManager
- Create drop down lists
- Use index and match formulas
- Hide rows and columns
- Hide or unhide sheets
- Generate random numbers between 0 and 9 with no duplicates
- How to hide command buttons by VBA
- How to change cell fill color
Let me know what you think. I’d love to hear from you. Is this version as much of an upgrade and easy to use as I think it is? I welcome any and all questions, comments, suggestions, cuss words, and compliments. Let me know using the comments below or via email. Enjoy playing Super Bowl Squares!