I'd like to combine the nutrition data from multiple meals during a single day onto a single row.
My knowledge of Excel is limited, and non-existent in terms of VBA.
Aof the new sheet. (Methods for doing that are documented all over the place.)
=SUMIF(Input!$A:$A, $A2, Input!C:C)(where
Inputis the name of the existing sheet, with all the meal data) into Cell
C2of the new sheet.
Here’s a screenshot
showing the data from Columns
D of your file: