![]() The drop down list was created with dependent data validation.The drop down list limits the food item selections, based on the Category selected in each row.įinally, enter the number of servings that you ate, based on the single serving amount that appears in the Measure column. In the example shown below, the measure is 175 mL (about 6 oz).Type a 1 in the Qty column, if you are eating a single serving of that size.Or, type a different number, such as 0.5 or 1.5, if you are eating more or less than a single serving size.Īfter you enter a quantity, the Calories column will automatically show the total calories in your serving of the selected food item.Īt the end of each day, click the "Save Daily Data and Clear" button, at the top of the FoodEntry sheet.That button runs a macro, named AddData, to save the food data, and clear the green cells. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |