Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 2, 2013, 01:56 AM   #1
shoelover4eva
macrumors newbie
 
Join Date: Jan 2013
Help creating a food costing spreadsheet on Excel

Hi there,

Im hoping someone out there can help me with how to create a speadsheet.

I have a food business and I need to create a costing spreadsheet. What I need is for a main sheet to contain all the ingredients in one column eg butter, flour. The next column will contain the unit cost eg. $.79. And the next column would need to contain the unit weight.

Then I was hoping to be able to use that list of items over and over again on mulitple recipes, (so that I dont have to retype each time). Maybe using drop down lists would be easiest. But I was hoping that the unit cost and price would also automatically insert also.

Im pretty stuck how to do this. I have made one before, but I have to copy the ingredients for each recipe manually.

Any help would be much appreciated.

I can email through my current spreadsheet so you can see what I am trying to achieve. I am sure I can do this in a more streamlined and simplier way.

Thanks in advance.
shoelover4eva is offline   0 Reply With Quote
Old Jan 2, 2013, 05:56 AM   #2
SpetsnaZ99
macrumors member
 
Join Date: Apr 2012
Location: UK
I think 'Hlookup' and 'Vlookup' would help if you are determined to use Excel. Other than that an Access database would handle it better. PM me if you want me to try the spreadsheet for you.
SpetsnaZ99 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Excel spreadsheet issues with iOS 6 dnkbro iOS 6 10 Aug 20, 2013 10:30 AM
Best spreadsheet excel app? roccobladr iPad Apps 0 Jan 2, 2013 11:28 AM
Are there any Word Perfect/Excel Spreadsheet apps? tpcollins MacBook Pro 5 Oct 8, 2012 03:17 PM
Excel 2011 Lags when more than one spreadsheet is open? Always Red Mac Applications and Mac App Store 0 Oct 2, 2012 07:25 PM
Creating Pivots in Excel 2011 that can be used in Excel 2003 (Windows) Extreme Red Mac Applications and Mac App Store 2 Jun 5, 2012 10:51 AM

Forum Jump

All times are GMT -5. The time now is 02:22 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC