Narayan,
1. Yes, the workbook KitchenInstructions would get it's dates from CustomerCalendarTemplate.
2. If you mean the order in which the data is sorted, then yes. If you mean the order of the coloums, then no. I need to group all of the same "Meal"s together then "Food Item"s together so...
http://www41.zippyshare.com/v/24700021/file.html
This is an example of how I want the finished Kitchen Instructions to look.
1. "Customer Name" would have the names of people who are signed up for the meals for that day, that information would be taken from the...
Narayan,
1/3. The maximum number of recipes is unknown to me, we are continuously adding/removing recipes.
2. Currently none of them are tied together, and this is probably the part I'm having the most difficulty with. I want to be able to take KitchenInstructionTemplate.xlsx and replace...
Narayan,
Thank you for such a quick response. I am currently making dummy copies of my files to upload and should have them available shortly. I will definitely look into Access.
Hello, my name is Gary and I have just recently started using Excel regularly for work. I am a chef for a company that prepares packaged meals for home delivery.
Currently, this is my method of assembling the customized menus:
1. Look over customer delivery calendar to see who is signed up...