• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy matching values, VBA Code


New Member
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