Hello,
I'm having issues creating a macro that takes the same tab name from all excel files within a directory when some of the tabs have different schema. All files have the same naming convention, however half of the tabs with the same name within these files have different schemas and cannot simply be read in with a wildcard convention in the file path. The reason the schemas are different is because each excel file contains data for one month of the year and all field names within each of the files are consistent until the month of May where a new field is added, changing the schema. Each file contains three tabs, but I only care about one of them and, again, the name of this tab is consistent among all files. I am thinking that I need either a batch or iterative macro but I just cant get it to work.
Due to my job, it would be a violation of protected information to share the files I am working with, but I hope I explained my issue adequately enough.
I hope someone can help me as I have not been able to find any documentation on this specific issue! I have only found how to read in multiple files with different schema or multiple sheets with different schema within one file. Please help!!
If needed I am happy to recreate three or four of the files with dummy data and share.
Thanks,
Danny
