Copy cell if Product are the Same

[cabete]

Hello every one.
I am try to do one macro for doing one think but untill now with no luck.
If you see my file i have one sheet for each shift were they selec one product and after they introduce the quantities produced , scrap, etc.
The next shift they can do the same product

What i want its a VBA that goes to sheet 1,sheet 2 and sheet 3 and see if are products equal and sum the quantity of the products , scrap and so one. And past it Report sheet.


This for all lines.

Anyone can help me. Try to do with Index but untill now without sucess.

https://www.dropbox.com/s/en9giwzety2e6r4/Relatorio de turno MODELO - net.xlsm?dl=0

 

[hiker95]

cabete,

I have had problems in the past when attempting to download an Excel file with macros, with the xlsm file extension.

Please remove all macros, and, then rename the workbook using the xlsx file extension, and, then repost on dropbox.


Then, in your next reply, post your new link to dropbox, and, all of your macro code.

When posting VBA code, please use Code Tags - like this:

[code=rich]

Paste your code here.

[/code]

 

[cabete]

Ok.

Dont know.

https://www.dropbox.com/s/lfk930o0robzxua/Relatorio de turno MODELO - net.xls?dl=0

Like you sugest

 

[hiker95]

cabete,

Your latest workbook/worksheets are in a different language that I do not understand.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[cabete]

In English

https://www.dropbox.com/s/lfk930o0robzxua/Relatorio de turno MODELO - net.xls?dl=0

 

[hiker95]

cabete,

I have had problems in the past when attempting to download an Excel file with macros, with the xls file extension.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.