Build me an Excel macro for restaurant inventory

Looking for an excel /Android app to be created for ordering food perishables in a fast food restaurant.

Process flow as follows:


1. Enter 'date': ddmmyy (max 7 dates)

2. Enter number of persons:

3. Enter number of staff:

4. Select 'time of day' for each date from droplist: breakfast, lunch, tea, dinner, snacks

5. Select any 4 'recipes' from droplist for each time of day:

Prepopulated list of recipes


Calculate and show report

Vlookup: 'ingredients' and 'quantities' for each recipe, for 1 person

Vlookup: max 3 'supplier names' for each ingredient


Sheet 1: aggregate Ingredient-wise total

(quantity) x (number of persons + staff) for all dates selected. Show all 3 supplier names for each ingredient.

Sheet 2: Recipes selected by date, time of day, for number of persons

Skills: Excel, Android, Visual Basic, Data Processing, Data Entry

See more: excel spreadsheet restaurant inventory, build sorting macro excel, excel macro build chart, build excel macro find replace, build replace macro excel, excel macro inventory system, macro warehouse inventory excel, excel macro stock inventory, warehouse inventory system excel macro, excel macro update inventory prices, excel macro based inventory control system, build excel macro

About the Employer:
( 2 reviews ) London, United Kingdom

Project ID: #21889905

22 freelancers are bidding on average £27 for this job


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

£100 GBP in 2 days
(342 Reviews)

Hi Sarajit I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know wha More

£20 GBP in 1 day
(258 Reviews)

Hello Sir Im excel VBA macro and formula Expert :) i can do your app restaurant in excel Sir via VBA macro. please ping me if you interested with me and we can discuss more for make sure everything before start Thank More

£50 GBP in 2 days
(386 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

£30 GBP in 2 days
(122 Reviews)

Hi, I have carefully reviewed the meticulously drafted details on the job post and understood all of your requirements (they are quite a few of them). Having successfully developed and deployed several such Apps workin More

£50 GBP in 3 days
(10 Reviews)

I can develop a food perishable items ordering system on excel/google spreadsheets/web applications, let discuss this in detail in chat or over a quick call. Please find below a brief introduction of myself. I am post More

£70 GBP in 1 day
(34 Reviews)

Hi, I can create a macro for your fast food restaurant. I can create form for the input and populate the output as requirements. Let's have a chat for detail discussion. I may have some questions for the requirements o More

£20 GBP in 1 day
(20 Reviews)

Hi there, I have over 6 years of experience in spreadsheet automation and scripting (Excel/VBA, Google sheets/GAS). I create fully automated dashboards, financial calculators, recipe calculators, user forms, automate More

£30 GBP in 2 days
(9 Reviews)

i can do it easily and i have also an alternate for you. come we will discuss. Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and More

£19 GBP in 1 day
(2 Reviews)

it`s an easy project and can be finished in less than the determined time please contact me to discuss the other details. Thank you.

£15 GBP in 1 day
(4 Reviews)

How are you I am a full stack web and mobile app developer and have 6 years experience. I read your project description carefully and I understand what you want. I have worked Android apps using Excel(CSV format) o More

£20 GBP in 7 days
(2 Reviews)

saya orang yang berpengalaman dalam administrasi Relevant Skills and Experience excel, word, power point

£20 GBP in 1 day
(0 Reviews)

Hi, I just saw your job task. I am interested to do. I am well known with excel and word. Can you give a chance to prove myself. Thank you

£15 GBP in 7 days
(0 Reviews)

Hi! With considerable experience pushing the limits of Excel's VBA/macro functionality, I can deliver your ordering interface with confidence. It will be easy to use, nice to look at, and reliable. Your reports will be More

£10 GBP in 2 days
(0 Reviews)

Hello, I am interested with your job offer. I am a Professional Data Entry with a high desire to enhance quality of work. I have faith that with my skills and experience for 3 years in this field will ease your compan More

£10 GBP in 3 days
(0 Reviews)
£18 GBP in 1 day
(0 Reviews)

I work in the restaurant industry as well and think this would be easy to make for you. Go ahead and contact me and we can work out some of the details. Thanks and have a good day.

£20 GBP in 3 days
(0 Reviews)

I am professional in MS excel, word, SAP, ERP, ORACLE, SPREED SHEET, PIVOT SHEET, ETC also experience in supply chain management, I have completed different project in excel, word etc. Regards Asif Mirza

£15 GBP in 6 days
(0 Reviews)
£18 GBP in 1 day
(0 Reviews)

I am a data analyst in a bank who works with Excel(with VBA) and access on daily basis and I can deliver this to you quickly! Relevant Skills and Experience I am a data analyst in a bank who works with Excel(with VBA) More

£15 GBP in 2 days
(0 Reviews)