I'm not too sure if this would be a formula or VB thing. I am making a
Yearly sales report/forecast. What I need to do is look up each part number
and pull the qty from each but only for specific customer (EX: Qty for p/n
1-1 but only for Cust b)
Tried vlookup but stops first time it hits the p/n. I think it would be
SUMPRODUCT or SUMIF but I'm not sure how that would be written. Thanks

Monthly sheet layout
Cust P/N Qty
a 1-1 4
a 1-2 3
b 1-1 8
b 1-2 7

New Sheet Layout (Customers are also grouped)
Cust P/N Jan Qty Feb Qty
a 1-1
a 1-2
b 1-1
b 1-2