Hello everyone,
So, I get two emails everyday from johndoe at gmail dot com and peterdoe at gmail dot com which have two excel files with daily data. I want to be able to automatically download these excel files when I get these emails from them and save them to my network drive/ hard drive in the format "filename_ today's date". Also, I have a master excel file and one of the sheets has the same formatting as that of the two excel files that I get everyday and I want the information to be automatically entered into the master excel sheet from these files that I get everyday. So basically these files that I get everyday, have that day's information in addition to previous information. Please let me know how I can go about this. Any leads would be appreciated.
Thank you.
Bookmarks