Hi, Im hoping someone can help me in automating a tracking sheet, i have various activites to complete each day which have a value assigned to them for points for completing the activity. These points are assinged to cells and given the value once the tick box has been ticked. How i want to automate it is:
- once the tick box has been ticked and the value has been given to then untick the tick box, but still have the value assisnged to the total for that day
- have a running total for total amount of points earned that isn't impacted once the tick box is unticked (atm once its unticked it loses its value)
- some sort of progress bar that is linked to the total amount of points that has the ability to be reset once a certain amount of points is reached, i.e level 1 is up to 100 points so the progress bar will be shown up to 100 points, then once its gets to 101 is it reset and level 2 begins and so on
This is what the sheet looks like:
This is what the messy tick box code looks like:
- once the tick box has been ticked and the value has been given to then untick the tick box, but still have the value assisnged to the total for that day
- have a running total for total amount of points earned that isn't impacted once the tick box is unticked (atm once its unticked it loses its value)
- some sort of progress bar that is linked to the total amount of points that has the ability to be reset once a certain amount of points is reached, i.e level 1 is up to 100 points so the progress bar will be shown up to 100 points, then once its gets to 101 is it reset and level 2 begins and so on
This is what the sheet looks like:
This is what the messy tick box code looks like:
