Currently have a fully functional Excel sheet, and I want a particular tab to be refreshed daily. The data within the tab would be an imported csv file, lets say located in Files/Dailydata-20190925.csv , I will have new datas saved in the folder everyday, so tomorrow there would be a new file called Dailydata-20190926.csv , how do I get my functional Excel sheet to read off the new daily files everyday with minimum input?
Bookmarks