Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.
Consolidate Excel Files from a Folder and Sub-Folders
Active Sheet: Tool will consolidate data from the active sheet of each file. The sheet which is visible when you open a file is called active sheet.
Sheet by Index: Tool will consolidate data from the sheet based on index position from the left. If you select this option, then you need to specify the index position as well
Sheet by Name: Tool will consolidate data from the sheet based on sheet name. If you select this option, then you need to specify the sheet name as well
Select or type the row number which needs to be used as header
If your data contain any non-blank column then select the checkbox and column name. Note that it is optional feature which helps to improve accuracy in data consolidation. If your data does not contain any non-blank column then leave the checkbox as unchecked
Now tool is ready to consolidate the data. Click on “Start Consolidation” button
Tool will start consolidating the data and show the progress on status bar. If you want to stop the tool in-between, then click on “Cancel” button
Once done, you will receive confirmation message as below
Data is consolidated and available in “Consolidation” sheet
You can refer “Logs” sheet to check file wise summary of consolidation
Consolidate Sheets from an Excel File
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. Here is a simple code for you,…
File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.
Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in Excel.
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.
Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time