I have a list of foods with nutrition data, so the name will be in a1, calories in b1, fat in c1 etc
I currently copy paste these in to another list where i can enter quantites or serving size
want to be able to type in the first letter of one of the items in the 1st in the cell where i would paste just now, then select from a drop down box or whatever, with the cals.fat etc being populated in the cells to the right of the name, so same format as the original list i'm copying from just now
I currently copy paste these in to another list where i can enter quantites or serving size
want to be able to type in the first letter of one of the items in the 1st in the cell where i would paste just now, then select from a drop down box or whatever, with the cals.fat etc being populated in the cells to the right of the name, so same format as the original list i'm copying from just now