For context we recieve a monthly Excel report every month that is automatically upload to our Sharepoint.

At the moment we have someone manually copy and paste the content from these newly uploaded files into a “master worksheet” that contains all the reports data in a single file. I want to know if there is a way that we that we can automate the process of updating this excl file?

The tabs and columns on all the Excel’s are exactly the same.

​For context we recieve a monthly Excel report every month that is automatically upload to our Sharepoint. At the moment we have someone manually copy and paste the content from these newly uploaded files into a “master worksheet” that contains all the reports data in a single file. I want to know if there is a way that we that we can automate the process of updating this excl file? The tabs and columns on all the Excel’s are exactly the same.  Read More

​