Alternately, the script could be improved to look for and delete blank rows within the master array before updating the master sheet.
In my today’s review I would like to dwell some more on the topic that I started in my previous post: working with Excel documents.
For example, if you have two sales reports using the same template, these can be merged quite quickly.
If the columns don't contain the same types of data in the same order, you will have to rearrange one of the worksheets before you can consolidate them.
The major purpose of the add-ins reviewed in this post is to take care of data types and formats upon themselves and let us tackle the main task – to merge and consolidate Microsoft Excel data coming from multiple spreadsheets.
So, here is a list of consolidating plug-ins for Microsoft Excel that I suggest you looking at: On the vendor’s web-site ( you will find a clear and comprehensible description of the add-in and its basic functionality.
Full Description: Spreadsheet Consolidator for Excel is an add-in for Microsoft Excel which will allow you to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easy and quickly.
Most of the time having the latest version of a software is a good thing.
He has taught computer science at Algonquin College, has started three successful businesses, and has written hundreds of articles for newspapers and magazines throughout Canada and the United States.To reduce the number of blank rows in between each Sales Rep data in the master sheet, each Sales Rep can manually delete blank rows at the bottom of their sheets.We don’t want the script to delete Sales Rep rows as a best practice (too risky).As you probably know, making a summary report is too general a task that will definitely require the user to gain the understanding of some abstract model of actions suggested to us by the developer if you want to solve your tasks quickly and successfully using a given add-in.All of us work with various specific documents, data types and ways of their presentation in Excel worksheets.