My GoogleFu is failing me with the proper keywords on this, I've only found the method for Access but it isn't very helpful for Excel.
I've thought of doing an Access Database in the past for stat keeping for my hockey league which I've looked for assistance with before. This time however I'm looking to make the initial score keeping easier, basically moving away from paper. Easiest way I can think of without having to program anything crazy is to use Forms inside Excel(which I'm currently using for tracking) that can be edited from a tablet, then saved/uploaded to OneDrive.
I'm currently stuck on how to have text boxes fill with data based on what is selected in a Combobox. Example:
A B C
Dec 1 Team1 Team4
Dec 2 Team2 Team5
Dec 3 Team3 Team6
Combobox contains the Date range selection, I want to select the date from the list and have the text boxes below it fill the Teams that are playing. Doing the date is easy but I'm missing the step on how to link the other columns to the date without having to do a huge IF statement(there are 90 games per year). I'm also planning on doing something similar for the goals/assists that links to other columns would be nice to use.
I'll probably run into more things I'll have questions about but this is a start.
Because if you're going to attempt to squeeze that big black monster into your slot you will need to be able to take at least 12 inches or else you're going to have a bad time...