Hello
I am trying to create an excel spreadsheet that calculates nutrition based on a dropdown menu. The values would change depending on the formula selected. How to I pull the data from sheet 1 and bring it in sheet 2 in order to calculate protein, carbohydrates and fat content. I have attached a copy of the excel spread sheet.
Sincerely
Nadoor1970
To refer to e.g. A1 on Sheet1 while you are not in Sheet 1, use this:
=Sheet1!A1
If you have given the sheet another name, use that name:
=MySheet!A1
If the name has a space in it, put the name between ' :
='My Sheet Name'!A1
In the thread title you are asking about a dropdown but I don't see that in your file. Do you need help with that too?
When I say semicolon, u say comma!
Hello
Not sure if L-Drr has answered your question but if not, as I understand it, you wish to have data validation cells with drop-downs to pull data from Sheet1. See the attached reply. It uses Index/Match with 3 named ranges.
DBY
This is exactly what i needed DBY. Thank you so much.
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks