Hi to all,
I’m trying to get the result in the following statement:
Sheet1:
Column A - I have the list of part numbers.
Column B - I have location (A)
Column C - I have location (B)
Sheet2
Data:
Column A - Part numbers repeated
Column B - locations repeated
Column C - Quantities
The result that I want is in sheet1:
Column B - the sum of all items in sheet2 Column B describe (A)
Column C - the sum of all items in sheet2 Column B describe (B)
I hope you understand this!! Lol
Thank you
I’m trying to get the result in the following statement:
Sheet1:
Column A - I have the list of part numbers.
Column B - I have location (A)
Column C - I have location (B)
Sheet2
Data:
Column A - Part numbers repeated
Column B - locations repeated
Column C - Quantities
The result that I want is in sheet1:
Column B - the sum of all items in sheet2 Column B describe (A)
Column C - the sum of all items in sheet2 Column B describe (B)
I hope you understand this!! Lol
Thank you