hi my replies are here below:
When using the workbook if i ticked along the column the sum of the calories overwrites the calorie data on the last entry, so in sheet A the calories for 60g of apricots now reads 877 Kcal! - I suppose that's a mistake, so i'm unsure what to do there..?
I ran the macro again on my file and didnt see the same problem. The sum of all the ticked cells will come at the bottom of your data.
(if the total number of calories appears outside my data fiels that would be fine as long as when the ticks are deleted everything reverts back)
I have put in an additional line of code so that when you click the reset button, even the ticks vanish from all the tabs. Hope that is fine with you.
what i'm after are instructions on what i need to do so that i can tick a food and the kcals are logged on the LOG sheet and be able to clear the data for a new day (MON to FRI) - once i've learned how to do that i'll be able to apply it to the other food data such as protein and carbs etc.
- Ultimateltly i'll be able to tick off the foods i've had in a day and the LOG sheet will tell me how many kcals, grams of carbs, protein etc ive had so i don't have to enter them manually
All you have to do is go to each tab, put in the tick marks. Come to the LOG sheet and click on the button stating "Calculate Calories". It will calculate all the calories and enter them into the LOG sheet. You can then click on "Reset" button to remove the tick marks and the sum fields in all the tabs.
Do let me know if you need any more clarifications.
Given below is the revised code. Just delete the previous code that i sent you and replace with this code.
Bookmarks