I have a file with different folders (a folder for each month of the year, so folders filtered by month), and every folder contains different Excel Files, 1 file for every day of the month.
So I want to create a robot that can copy the Excel File with “Yesterday’s” date, and check all the folders because it may be in one of them not necessary in the folder of this month.
And then copy it to a destination folder.
Any idea how can I do this?
Many thanks for your help!