Checkboxes in cells
Hi! I want to make a practicing log for my rehearsals in Excel. I want the opportunity to practice at least three times during a day and each time I practice during a day I want to save what I have practiced and for how long. For instance I can have thee columns:
Warming up, Pieces, Technical rehearsals
16 min, 19 min, 12 min.
In each rehearsal I do, I want to have sub-rehearsals. For example, when I am warming up, I usually do some 'long tones' and 'breathing exercises'. I want to have a list in the top of the document that will look kind of like this:
Waming up:
-long tones
-breathing exercises
Pieces:
-Neruda's trumpet concert
Etc.
I want these to have checkboxes and that within each day I can 'save' which of these things I have rehearsed. Said in another way: In each cell there is saved which of these tings I have checked off, so when I move to another day/cell, the boxes I have checked off is different.
I have attached a simple idea that I want to improve so I dont need to write in every cell what I have practiced.
|