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

Квалификация: Excel, Android, Visual Basic, Обработка данных, Ввод данных

Показать больше 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

О работодателе:
( 2 отзыв(-а, -ов) ) London, United Kingdom

ID проекта: #21889905

22 фрилансеров(-а) в среднем готовы выполнить эту работу за £27


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 Больше

£100 GBP за 2 дней(-я)
(342 отзывов(-а))

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 Больше

£20 GBP за 1 день
(258 отзывов(-а))

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 Больше

£50 GBP за 2 дней(-я)
(386 отзывов(-а))

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] Больше

£30 GBP за 2 дней(-я)
(122 отзывов(-а))

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 Больше

£50 GBP за 3 дней(-я)
(10 отзывов(-а))

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 Больше

£70 GBP за 1 день
(34 отзывов(-а))

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 Больше

£20 GBP за 1 день
(20 отзывов(-а))

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 Больше

£30 GBP за 2 дней(-я)
(9 отзывов(-а))

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 Больше

£19 GBP за 1 день
(2 отзывов(-а))

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 за 1 день
(4 отзывов(-а))

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 Больше

£20 GBP за 7 дней(-я)
(2 отзывов(-а))

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

£20 GBP за 1 день
(0 отзывов(-а))

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 за 7 дней(-я)
(0 отзывов(-а))

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 Больше

£10 GBP за 2 дней(-я)
(0 отзывов(-а))

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 Больше

£10 GBP за 3 дней(-я)
(0 отзывов(-а))
£18 GBP за 1 день
(0 отзывов(-а))

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 за 3 дней(-я)
(0 отзывов(-а))

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 за 6 дней(-я)
(0 отзывов(-а))
£18 GBP за 1 день
(0 отзывов(-а))

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) Больше

£15 GBP за 2 дней(-я)
(0 отзывов(-а))