Calorie Counter

**sharp21** · 04-25-2005, 08:59 AM

Im creating a a spreadsheet to track daily nutritional information. It is my first one.
On the first sheet I have info on various foods as I come across them. On subsequent sheets I input what I eat daily & it autosums the calories, protein, etc.
What I would like to do, is have it so that I can just type in the food, ie banana, & it will automatically take the values from the first page & input it into subsequent sheets, so that i do not have to re-type or copy paste.
thanks
S.

**MartinShort** · 04-25-2005, 09:02 AM

The Syntax is

=Sheet1!A1

etc.

**MartinShort** · 04-25-2005, 09:05 AM

A useful tip for typing in multiple sheets simultaneously is to "<Control> and <Click>" all of the sheets you wish to type on and the type on. Start typing and you'll find that whatever you've typed is now on EVERY sheet. Remember to deselect the multiple sheets when you've finished though.

**swatsp0p** · 04-25-2005, 10:01 AM

I don't think Martin addressed the OP's question. It sounds as if they need a VLOOKUP. On Sheet1, make sure your data is laid out in the following format:

Col A is the item (e.g. Banana)
Col B is Calories
Col C is Protien
and so on

This range of data must be sorted Ascending by Column A. Name this range of data "Foods" (or similar)

Now, on Sheet2, set up columns the same order as Sheet1

Use Column A to enter your foods eaten.

Assuming your first entry is in A2, in B2 enter this formula:

=VLOOKUP($A2,Foods,2,0)

In C2 enter this:

=VLOOKUP($A2,Foods,3,0) note that the column reference '2' changed to '3'

repeat this formula in as many columns as you have data in your Foods range, adjusting the reference number to match the column number (B is col 2, C is col 3, etc.)

Then, copy these formulas down through as many rows as you need.

HTH

Bruce