Hey all,
I have seen quite a few posts lately about dynamically unioning multiple excel sheets into one stream. This is such a common use case, I thought it would be helpful to create macros that did this for both XLSX and CSV files.
The links below take you to the gallery page to download each. They allow you to input the directory, check if you want to include subdirectories, and choose the starting row number for the data.
The only caveat is all the files must start on the same row, other than that, they will pull the respective files in and union them together regardless of schema.
Dynamic XLSX Input
Dynamic CSV Input
I hope this is helpful for everyone, I would love to hear about if it's useful or if anyone has suggested changes to it.
Bacon
