Hey everyone,
I have around 80 or so files that are all named something different but located in one folder in a SharePoint folder. I have a master file as well which is also in that same SharePoint folder. I need to pull data from a specific worksheet from each of the 80 files (named Code Block Detail). The 80 files are just copies of a single template with different information in each. I need to set up the macro to pull the data from those 80 or so files and import them into the master file on a certain date of the month (let's call it the 4th of every month). The reason to pull the data on a certain day is so that Project Managers can go in and edit stuff throughout the month without having to worry about the new data getting uploaded before they are ready and risk having it overwrite with wrong data.
Thank you in advance to whoever can help.
I have around 80 or so files that are all named something different but located in one folder in a SharePoint folder. I have a master file as well which is also in that same SharePoint folder. I need to pull data from a specific worksheet from each of the 80 files (named Code Block Detail). The 80 files are just copies of a single template with different information in each. I need to set up the macro to pull the data from those 80 or so files and import them into the master file on a certain date of the month (let's call it the 4th of every month). The reason to pull the data on a certain day is so that Project Managers can go in and edit stuff throughout the month without having to worry about the new data getting uploaded before they are ready and risk having it overwrite with wrong data.
Thank you in advance to whoever can help.
