Combining daily XLS data from email

[Larry_in_Missouri]

This is my first post, so if I break any rules, or omit any needed info, please let me know.

I receive an email daily summarizing the performance of my solar system. If I can figure out the mechanism, I will post an example. Anyway, each day is a row with the date as column 1. What I would like is the easiest way to consolidate these individual files into one worksheet simply adding each succeeding day into the sheet. Each individual report is downloaded to my "documents" folder and is in XLS format. The file originally arrives as an attachment to an email. If the process could be automated to find the file in Outlook, then consolidate, that would be more than excellent, but a simple merge of the data would be quite fine.

Thanks in advance for your help

[saravnepali]

Assuming the data will be of the same format, as the tnable
' file is saved as ddmmyyfilename like 28112019nameofmyfile.xlsx
'change folder names to suit

Put the following code on master sheet and when you run it get data from the daily updated spreadsheet to this sheet

Please Login or Register  to view this content.