Macro Request Pivot Table Value Copy to Template Sheet

[ganeshinscribe]

Hi all,

Please find attached our working Excel sheet and kindly do the better solution to automate this manual process.

Workbook: MACRO.XLSX
Sheet1: DATA – Listed client order data
Sheet2: PIVOTTABLE (Sum of shipped Qty by client id)
Sheet3, 4 & 5: DATATEMPLATE – Need to paste pivot table values as based on the week.

Here attached Excel, I have manually processed all the data template sheets. I will expect your guidance to do this process via macro.

Please do the suggestions and guidance for the same.

Thanks