I want to create a Macro that will open multiple Excel files from a specific folder location based on the Modified dates & file name, and then copy paste it to a new spreadsheet.
For example, please see screenshot below: I want to open a file that the file name contains "Apple" for 8/10/2021 from a folder (C:\Users\xli\Desktop\Water). and then copy paste the data of this spreedsheet (A2:H10)to a master excel file and then close this apple file. and then open another apple file for 8/9/2021 from the same folder and copy past to the master file....and then do the same for the 8/6 apple file..... I have a list of the dates that I need in the master file. I need to do this on a monthly basis so the dates change every month. Is it possible to do this in Macro? Thank you so much for your help in advance!
For example, please see screenshot below: I want to open a file that the file name contains "Apple" for 8/10/2021 from a folder (C:\Users\xli\Desktop\Water). and then copy paste the data of this spreedsheet (A2:H10)to a master excel file and then close this apple file. and then open another apple file for 8/9/2021 from the same folder and copy past to the master file....and then do the same for the 8/6 apple file..... I have a list of the dates that I need in the master file. I need to do this on a monthly basis so the dates change every month. Is it possible to do this in Macro? Thank you so much for your help in advance!