I get a spreadsheet every morning for the products that are ordered. I cant figure out a way to count each of the products with their respective variation. Is there a way to copy and paste this into a spread sheet to get an automatic tally of the orders?Morning Tally.ods
I made an Sheet for you for summary your orders.
Copy the order in exactly the same style into the Import worksheet. Simply delete the old entries first. Then an overview of the breads to be baked with the corresponding variations is created in the worksheet Summary.
If the totals in cell A1 vary, the formulas must be extended.
In Import, up to row 1000 is analyzed. If there are more orders, the formulas must be adjusted.
I hope this helps. For questions please simply contact us again.
When the question is answered, please click on the check mark next to my answer. Thank you.
THANK YOU SO MUCH
when you happy with my answer, then please mark it as answered. Thank you