The File Consolidator imports the worksheets of multiple workbooks into one file.
All files (of either .xlsx or .csv extension) in the selected folder will be imported and the user will have the option to either merge the data from each individual worksheet into one worksheet, or to keep each worksheet separate.
When merging data into one worksheet the user can choose whether to include the headings from each worksheet or to only use the first set of headings.
All files (of either .xlsx or .csv extension) in the selected folder will be imported and the user will have the option to either merge the data from each individual worksheet into one worksheet, or to keep each worksheet separate.
When merging data into one worksheet the user can choose whether to include the headings from each worksheet or to only use the first set of headings.