Hello, copying data from a file, or several, when they've different names is not a problem, however, how do I copy data from multiple files (and paste it all one under another) when the names are different each time? The layout inside (columns A to Z) never change though.
It's not possible to specify file names since it'd cause too much manual work.
In short, e.g. a user selects 10 files and their contents are imported on a last row +1 basis.
Your help is greatly appreciated.
Many thanks!
Bookmarks