Copy matching values, VBA Code

[shreydas22]

Hi All,

I am new to VBA and am looking to write a VBA code that will match a product (in sheet one listed in rows) to product (in sheet two listed in columns) and then copy the total weekly value from sheet one to corresponding week in sheet two. I am looking to only copy the total values for a product and not the individual sub products values.


I am attaching a sample sheet for reference.

Many thanks in advance

 

[vletm]

shreydas22
One sample
... press [ Do It ]-button