Creating Path to different folders
Can anyone help with this request:
I would like to read all excel files in subfolders that have the same name within folders that have different names.
For example I have folders based on countries:
FRANCE
ITALY
GERMANY
And within each of the mentioned above I have subfolders with a specified FY:
2122
2223
2324
I would now like my workflow to automatically read and combine all excel files „2324“ since they have the same format.
What‘s the best way to do this?