You have no data in Sheet2. I am not sure what you are asking for. Please clarify with a detailed explanation of how you would do it manually and show a couple of examples of that. Otherwise we are just guessing at what you want. Trying to decipher code without an explanation of the desired results is very difficult. Please be explicit in your explanation.
hi, AlanSidman first of all there are data in sheet2 but you don't pull the arrow in down the second what i would in sheet 1 contains the data from range a5:e and the sheet2 from range a4:g sometimes in sheet2 there are repeat data the same thing in sheet1 here i want sum the data in sheet1 from b5: e with sheet2 from c4:e and show the result in sheet2 from L4 TO O(NOTE: i would sum buplicated repeated brand and show it one time) you can check my code where is the mistake
i hope this clear