Ask Your Question
0

Baked goods counting

asked 2020-08-16 19:35:23 +0200

Flaxbread gravatar image

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?C:\fakepath\Morning Tally.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-08-16 22:17:30 +0200

dscheikey gravatar image

Hi Flaxbread,

I made an Sheet for you for summary your orders.

C:\fakepath\Morning Tally.ods

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.

Best regards

Juergen

edit flag offensive delete link more

Comments

THANK YOU SO MUCH

Flaxbread gravatar imageFlaxbread ( 2020-08-18 00:29:39 +0200 )edit

Hi,

when you happy with my answer, then please mark it as answered. Thank you

dscheikey gravatar imagedscheikey ( 2020-08-19 01:39:08 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2020-08-16 19:35:23 +0200

Seen: 53 times

Last updated: Aug 16 '20