Job description
I need sheet no.1 where I will add customer orders from the left in columns: customer email address, product name, quantity (here may be several products - I do not know how to solve it), parcel code, order number, status - shipped, not shipped (assigning to a particular shipper on sheet no. 2 according to filters),
sheet no. 2 shippers: e.g. shipper no. 1 we set them freely to a given group of customers, e.g. only green or green+green
I would also like to be able to assign a given customer's e-mail to a given group of customers manually, i.e. enter the customer as a green customer even if there is no order at all.
sheet no. 3 customer groups
here we set for example
RED CUSTOMER - up to 5 orders up to 10 quantities from 6 can be handled by the sender which we will activate by ourselves YELLOW CUSTOMER from 6 orders over 10 that is from 60 quantities and 6 orders or from 4 orders when orders over 20 that is from 80 quantities and 4 orders.
green customer - from 4 orders over 250 units
I would like to highlight in green, yellow or red the given customer's email, if he has already entered the given customer group.
