Hello all,
I work with sheets from several files. All of them with the same structure and secuencial name, generated autotically everyday.
To ease the work, Im looking to a way to merge automatically the 10 most recent files from a folder into one simple sheet.
Example:
File1:
A -- B -- C
File2:
D -- E -- F
Merged file:
A -- B -- C
D -- E -- F
Already Im just doing copy-paste and I want to automatize this as much as I can.
Thanks in advance.