shreydas22
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
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