Merge Duplicate Rows sum Values

Need help to do following steps with formula or vba code              
                       
I’ve data in this format on 1st sheet                  
Date Quality Contract Color Source  Quantity   Shifts   Hours   Contractor   Rate   Amount   Unit 
01/09/2018 68*42 EM-42033 Black NFL              474         6.00            48  NDF         490    2,940.000  Unit-51 
01/09/2018 108*54 SC-50061 Guan Camo NFL           7,000       46.00          368  NDF         490  22,540.000  Unit-21 
01/09/2018 68*42 EM-42033 Black NFL              600         7.00            56  NDF         490    3,430.000  Unit-51 
01/09/2018 132*56  TF-39427 Black NFL           3,000       14.00          112  NDF         490    6,860.000  Unit-21 
                       
on 2nd sheet data should be sort automaticaly by contract, color and source            
                       
Date Quality Contract Color Source  Quantity   Shifts   Hours   Contractor   Rate   Amount   Unit 
01/09/2018 68*42 EM-42033 Black NFL              474         6.00            48  NDF         490    2,940.000  Unit-51 
01/09/2018 68*42 EM-42033 Black NFL              600         7.00            56  NDF         490    3,430.000  Unit-51 
01/09/2018 132*56  TF-39427 Black NFL           3,000       14.00          112  NDF         490    6,860.000  Unit-21 
01/09/2018 108*54 SC-50061 Guan Camo NFL           7,000       46.00          368  NDF         490  22,540.000  Unit-21 
                       
on 3rd sheet duplicate sorted data (rows) should be merged automaticall and sum value of quantity, shifts, hours and ammount excep rate    
                       
Date Quality Contract Color Source  Quantity   Shifts   Hours   Contractor   Rate   Amount   Unit 
01/09/2018 68*42 EM-42033 Black NFL           1,074       13.00          104  NDF         490    6,370.000  Unit-51 
01/09/2018 132*56  TF-39427 Black NFL           3,000       14.00          112  NDF         490    6,860.000  Unit-21 
01/09/2018 108*54 SC-50061 Guan Camo NFL           7,000       46.00          368  NDF         490  22,540.000  Unit-21 

By: Kaleem

Leave a Reply

Your email address will not be published. Required fields are marked *