Need an Excel Expert! -- 2
Budget: $200 – $201 USD
Dear Experts,
Please kindly see attached excel file.
I have day 1,2,3 to 29,30,31 worksheets in this excel.
I need the daily details like, "Name, Location, Dinner, Lunch" to be sent to worksheet "Monthly Orders" for easy compilation.
After manually adding the prices of each orders in "Monthly Orders", I need to create invoices at end of the month for each orders.
So if I input a "P" at "Monthly Orders", It will pull the date 1 - 31 to Invoice so that we can print the invoice for the customers.
And I need to print label stickers from the "monthly orders" daily, eg date 1 = 8pax from Khairul, 38pax from Zhong Jian, 7pax from TKH.
Hope you guys understands what I'm talking about and hope that you can assist me in this arduous matter.
Please kindly see attached excel file.
I have day 1,2,3 to 29,30,31 worksheets in this excel.
I need the daily details like, "Name, Location, Dinner, Lunch" to be sent to worksheet "Monthly Orders" for easy compilation.
After manually adding the prices of each orders in "Monthly Orders", I need to create invoices at end of the month for each orders.
So if I input a "P" at "Monthly Orders", It will pull the date 1 - 31 to Invoice so that we can print the invoice for the customers.
And I need to print label stickers from the "monthly orders" daily, eg date 1 = 8pax from Khairul, 38pax from Zhong Jian, 7pax from TKH.
Hope you guys understands what I'm talking about and hope that you can assist me in this arduous matter.