Otherwise, the wrong items might appear in the Food Item drop down list.Īfter you select a food item, its measurement appears, and you can enter the quantity that you ate, based on that measurement. This list comes from the FoodList sheet, so it’s important to keep the FoodList sheet sorted by category. There’s a dependent data validation drop down list in the Food Item column, based on the Category that you select. The Meal/Snack and Category source lists are stored in named ranges on the Lists sheet. In the green data entry cells, there are drop down lists, created with Excel’s data validation. There are only 22 rows for data entry, so that should help limit your food intake! In the main sheet, named FoodEntry, you can enter the date, your target calorie count, and all the foods that you eat. Click the check mark at the left, to confirm the change, and click CloseĪlso, see below, for adding more columns to the Daily Calorie Counter The Daily Calorie Counter.In the Refers To box, at the bottom, change the number of columns, from 3, to the number of columns in your revised table.In the list of names, click on FoodLookup. ![]()
0 Comments
Leave a Reply. |