Hi All,

I appreciate if anyone can help me. I have a VBA code in the "downloaded report". If I run it, the code will copy "pivot table look like" sheet and paste in the same workbook by creating a new sheet. This works great and have no issue.

In addition, I also want to save this data in the last available row of another workbook called "Master Data" and add week # in the first column. The week # can be taken from the downloaded report.

I have attached both workbook for reference. Please advice.

Regards

Sha

downloaded report.xlsMaster Data.xls