Not sure where to post this, so I will try it here.

I am not sure how to adequately post this question, but I will try.  Currently, I have an excel file that I use to track my daily food intake, and calories burned.  I have it set up such that each day is a new tab, and I simply copy each tab and rename to the next day.  Therefore, all the “data” is mostly repeated. 

Here is an example of what part of it currently looks like: 

Columns A to L are the "data", columns N to W are the results of cell C2*D2, E2, F2, etc.

I would like to be able to click on cell A2, and have it be a pull down, where all the food choices from a "data file" are listed, then I select "2 egg omelet" and just have to put in the proper amount.

Is this possible?

Javan

Unfortunately your table has been truncated as it is too wide for the window.

I believe we can use data validation here. Set up your list somewhere and then use Data>Validation.. and select 'list' from the 'allow' dropdown (You could type a comma seperated list in the 'source' box if you want). If the list is on another sheet, use a named range (Insert>Name>Define...) and refer to that in the source box (e.g =RangeName)