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
Bookmarks