Hi
I am creating the attached workbook through VBA code on the raw data, and this part works perfectly. providing me with a summary of each day (file)
I wanted to know if there is a way to create a code that would be able to create a master summary workbook.
Basically I would have these daily worksheets created each day by running the macro providing a summary sheet of the data from that day (as per attached file). All of these stored in one folder on my drive.
I would like to be able to have a new master workbook that looks at the folder where these files are stored recognizes when a new file has been added and then copies the data from that summary sheet and pastes that data as new line in the Master Summary worksheet.
I had found some code to open newest files in a folder, but there maybe times (after a weekend) when I could have 3 days files generated and put into the folder on a Monday, so this code would only pick up the most recent. Which is why I thought a search for un-inputted files would work better.
Would appreciate your suggestions.
Many thanks
Jon
Bookmarks