How can I compare item SAP and Excel by selected some item inline for an update?

HI, please anyone help me!
In sheet1 it need to go through each row in row1 it contains CERVERE after it need to observe Qualifica column if it contains operai then we need to take that total count and upadate in sheet2 in that BLUE COLLOR column if it is other than operai then we need to update count in sheet 2 according to its name in white collar column.