food

Hello everybody and thanks in advance for reading this, I've been toying with an idea for a menu selector. My partner and I usually squabble about what to eat and we've decided to outsource it to a neutral party. We want to load up some excel sheets with dishes we both like, with the required...

Hello to all, I am using this formula: =IFERROR(INDEX('[Pie Face Central ******* Food Costing File.xlsx]Recipe'!$L$2:$L$3100,MATCH(U466,'[Pie Face Central ******* Food Costing File.xlsx]Recipe'!$H$2:$H$3100,FALSE),1),"") My question is, if I have the reference cell located on different...

Greetings, I'm self-taught in Excel. Unfortunately, that may be why I'm not well-versed in Excel jargon, and that's probably why I'm having such a hard time looking up the information that I need. Cutting to the chase, I need to create a dropdown list that, depending on the item selected...

Hello everyone, I am trying to build a P&L that I can slice and dice as required. I get data for multiple sites and need to ability to into with a few clicks. I have the data in the below format: <tbody> Site Name Category Period 1 Period 2 Period 2 Period 3 Delta Drink Sales 5 10 15 20...

Hi there! First post here, but have been visiting now and again for hints and tips. I'm responsible for organising our Xmas lunch this year so I have created a spreadsheet. Tab 1 has all the menu choices. It has the names of the attendees going down in Column B. In Columns C to O going across...

I'm setting up my budgeting spreadsheet. I want the pie chart to show how much I spend on each thing (food, bills, socialising etc). At the moment it shows each 'food' etc instance as a separate part of the pie chart rather than their collective cost. It also shows empty items on the key. How...

The question goes like this: Last year, the Tan household spent $11,000 on food, $5,900 on transportation, and $7,200 on other expenses. The cost increases per year by official estimates for food is 4.5%, transportation is 6.2%, and others are 8%. The family's total income in the previous year...

So I am trying to automate my produce inventory for a hotel and I can't seem to get the code right to pull costs from one sheet to another when a certain cell matches (the item #). An example of the sheets I have are below. I was able to automate the C-D column cells, however with the E-F...

I have a WORKBOOK named "Inventory". It consists of several WORKSHEETS that divide my food inventory into categories such as "MEAT", "DAIRY PRODUCTS", etc. I recorded a macro that will import my inventory from an online ordering system, dump it to a WORKSHEET named "IMPORT" and normalize the...