Hello guys,

I have a senerio and I need to automate this to reduce my work.
senerio: We are a team of 20 working in a small company. Every day we order lunch from 3 different Restaurant.
Currently, every guy send me his order looking at the menu. I have to sort it based on the restaurant and send it to respective restaurant. I also have to keep in track of the bill.
Instead of receiving the mail from each, can we automate this in excel and get final orders separetely for each restaurant.
Please help.

Thank you