add new file & merge duplicate item for each sheet alone

Hi Guys
I have many sheets contains duplicate items , what I want merging duplicate items for each sheet alone( not across sheets ) based on column C . as to summing values should just be the columns QTY,TOTAL and should ignores columns DATE(should replace of it numbers 1,2,3) , ORDER,PRICE when merging should be as in the result in file RESULT .
note: this is simple data , but my real for each sheet could be 2000 rows .
thanks

add new file & merge duplicate item for each sheet alone

Originally Posted by KalilMe

I want merging duplicate items for each sheet alone( not across sheets ) based on column C . as to summing values should just be the columns QTY,TOTAL and should ignores columns DATE(should replace of it numbers 1,2,3) , ORDER,PRICE when merging should be as in the result in file RESULT .

Please Login or Register  to view this content.

awesome !!
can I do that without select the file from browser,please?
just I put the macro in file COLLECTION and when run it add new file RESULT
thanks

Please Login or Register  to view this content.

thanks but isn't like the orginal code . the code ignores column Total and not ignore column PRICE when merge

Mistook of column references.

Please Login or Register  to view this content.

it gives error #REF in column TOTAL in file RESULT .

Upload the workbook with the code that is giving you such error.

here is the file

OK, add one line in bold.

Please Login or Register  to view this content.

thanks again
there is too strange case in sheets ("STA","RPA") . it gives wrong values for duplicates items into column (TOTAL) after combining .
I highlighted the wrong values and put the right value beside it in column H .

Look at your RESULT.xlsm in your initial post.

G2 in STA is showing as TRY 8,400.00, so I just did it.
Add 2 lines

Please Login or Register  to view this content.

Look at your RESULT.xlsm in your initial post.

G2 in STA is showing as TRY 8,400.00, so I just did it.

I'm really sorry about it .
thanks very much for everything .