stavrosiona
New Member
- Joined
- Apr 17, 2015
- Messages
- 22
Hi I am creating an excel where in 1 sheet I will take lets say the order:
i.e:
Date, Customer Name, Product Code, Qty
and on the sheet 2 I will have on the A column all the products and on A2, A3,A4, A5 .. all the customers.
What I want to do is to be possible the Sheet 2 to read from Sheet 1 and do the following:
Add the qty order in sheet 1 for specific customer in the sheet 2 under the raw and line of the product for the specific customer.
Step 2 is in case a customer order today on the 28/05/2019 1 piece pf product 2 and after some days i.e 10/06/19 one more of the same product so the sheet 2 to do the ADD and show in sheet 2 under specific customer i.e Cust 2 the qty of Product1 to be 2.
Example f Sheet 1 :
Date, Customer Name, Product Code, Qty
28/05/19 Cust2 Product1 1
10/06/19 Cust2 Product1 1
See example of sheet 2 bellow:
Product Orders Cust1 Cust2 Cust 3 ...
Product 1 2
Product 2 1 1 1
Product 3 2 1
Product 4 3
i.e:
Date, Customer Name, Product Code, Qty
and on the sheet 2 I will have on the A column all the products and on A2, A3,A4, A5 .. all the customers.
What I want to do is to be possible the Sheet 2 to read from Sheet 1 and do the following:
Add the qty order in sheet 1 for specific customer in the sheet 2 under the raw and line of the product for the specific customer.
Step 2 is in case a customer order today on the 28/05/2019 1 piece pf product 2 and after some days i.e 10/06/19 one more of the same product so the sheet 2 to do the ADD and show in sheet 2 under specific customer i.e Cust 2 the qty of Product1 to be 2.
Example f Sheet 1 :
Date, Customer Name, Product Code, Qty
28/05/19 Cust2 Product1 1
10/06/19 Cust2 Product1 1
See example of sheet 2 bellow:
Product Orders Cust1 Cust2 Cust 3 ...
Product 1 2
Product 2 1 1 1
Product 3 2 1
Product 4 3
