I am looking to add a template to my excel file, dependent on what is selected in a cell from a drop down box.
Basically, I order a lot of food for people from 3 different outlets and instead of them emailing it to me and then having to create each order separately, I wanted to simplify the process and allow them to place their own orders.
For example:
Cell A1, would contain a VLOOKUP to a master resource list, so they can select there name from a drop down.
Cell A2, would contain a drop down with either Indian, Chinese, or Pizza as the selection choice.
Dependent, on what was selected in A2, an order template would be shown under these cells.
They would then create their order and click a "submit" button, which would then transfer the data to an order spreadsheet containing 3 tabs, Indian, Chinese, or Pizza.
I have attached a sample pizza order template, I was just looking for some assistance as to whether this is an easy task to complete?Order Template.xlsx
Bookmarks