I need help with some Excel.

P

posts from hell

New Member
Joined
Nov 30, 2004
Messages
9,371
Reaction score
10
I need to make some spreadsheet to keep track of the food I eat.

So, here is what I want to do - Make a database as I go along. I'll be inserting the nutritional values of whatever I'm eating in this database.

In the main spreadsheet I want to be able to put in like for example -

Cell A1 has the word "Orange" and the cell B2 has 100 grams. Then it will automatically calculate the nutritional values in following cells.

What I need help is - How do i build the database in a separate spreadsheet and pull the information over when I type in the word. The weight will be a formula that I will put in.

Many Thanks.
 
I wish I could help but I am not sure if you still have me in Ignore......:aw:
 
And you're going to stay ontop of that?

I tried making a database of my diet. I just gave up... easier to memorize the calories of the food I put in and calculate it in my head than it is to keep track of it.
 
souggy said:
And you're going to stay ontop of that?

I tried making a database of my diet. I just gave up... easier to memorize the calories of the food I put in and calculate it in my head than it is to keep track of it.
Click to expand...

Yeppers. My roommate will make me stick to it.

If you want to become a professional cyclist, you gotta do what you gotta do.
 
posts from hell said:
Yeppers. My roommate will make me stick to it.

If you want to become a professional cyclist, you gotta do what you gotta do.
Click to expand...

The one I gave you is from Lance Armstrong's foundation. ( Sort of famous pro bike rider.)
 
Have you tried Connections under the Data tab (assuming you are using Office 2007)?
 
Im good @ excel

What I think you need to use is Copy special and paste special if you want to copy a value in a cell from worksheet 1 to worksheet 2. Is that what you mean?
 
No.

He just want to type what he had for breakfast like:

an orange, one slice of french toast and a large pizza, with details how much each of those individual things weigh in a separate column.

The food he lists is linked to a preset number that will help him figure out how much calories he had.

Like say... an orange is 50 calories... and he had two oranges... he type in oranges, 200 gram. It outputs how many calories he had by eating 2 oranges which is 100.
 
If what he means to sum the cell say from c5 to c12 which you would write in C13 as =sum(c5,c12) Or he can do this pick any cells like maybe F15 he could still type in =sum(c5,c12) in that cell

Hope this helps

DHB

souggy said:
No.

He just want to type what he had for breakfast like:

an orange, one slice of french toast and a large pizza, with details how much each of those individual things weigh in a separate column.

The food he lists is linked to a preset number that will help him figure out how much calories he had.

Like say... an orange is 50 calories... and he had two oranges... he type in oranges, 200 gram. It outputs how many calories he had by eating 2 oranges which is 100.
Click to expand...
 
diehardbiker said:
Im good @ excel

What I think you need to use is Copy special and paste special if you want to copy a value in a cell from worksheet 1 to worksheet 2. Is that what you mean?
Click to expand...

souggy said:
No.

He just want to type what he had for breakfast like:

an orange, one slice of french toast and a large pizza, with details how much each of those individual things weigh in a separate column.

The food he lists is linked to a preset number that will help him figure out how much calories he had.

Like say... an orange is 50 calories... and he had two oranges... he type in oranges, 200 gram. It outputs how many calories he had by eating 2 oranges which is 100.
Click to expand...

Both is correct.

In one worksheet I will list the things I have in my diet. All the stuff I eat.
In the "Database" worksheet I will have a row of data, calories, protein, carbs, sugars, fibers, etc.

In the main worksheet I will be putting in just "Oranges" and the weight. It will retrieve the data from the database worksheet and multiply it by the weight so I can get as close to an accurate count.

I'll also be making another spreadsheet to track my daily intakes. That way I can really compare.
 
Yes, but he doesn't just want formulas. He just want to be able to link formulas to the actual words.

Type in orange, in a separate field... it says 50.
 
So are you saying you want to tie up some values between worksheets, right? I remember programming it but seems can't get it working at this time. I am trying to remember how to do it right.


posts from hell said:
Both is correct.

In one worksheet I will list the things I have in my diet. All the stuff I eat.
In the "Database" worksheet I will have a row of data, calories, protein, carbs, sugars, fibers, etc.

In the main worksheet I will be putting in just "Oranges" and the weight. It will retrieve the data from the database worksheet and multiply it by the weight so I can get as close to an accurate count.

I'll also be making another spreadsheet to track my daily intakes. That way I can really compare.
Click to expand...
 
Yea, I'm looking up on how to make the hlookup command kinda dynamic.

The problem obviously is that I have never been educated in excel. (and its the 2007 version, I have the 2003 as well)

I've gotten things going pretty well in ONE workbook with =hlookup.

Now Onto to figuring out how to use the hlookup with several workbooks.

This is the best thing i can think of.
 
Back
Top