hi all, thanks for reading.
trying to set up an excell sheet for food.
what im trying to do is when i type in eggs for example, i want excell to auto fill the stats below, for carbs, protiens, fats ect.
i know ive to progam it somehow, but how. if i set up all the foods im using on the next sheet, can i program excell to auto the data as i type rather than adding all the data every time.
so as soon as i type, eggs, all the fields below at filled in at the same time.
cheers for any help. using ms office 2007.