ExcelSuite 4.2.4.2 - A great software to process Excel workbooks.

ExcelSuite

ExcelSuite: ExcelSuite is an application that can process data across numerous Excel workbooks.<br><br> 1.Add up the same cell across worksheets<br> Is there a way to add the same cell (ie.A1) from multiple worksheets without manually having to input sum (Sheet1:A1, Sheet2:A1, Sheet3:A1…)? Yes it is! With it you can merge multiple worksheets of the same format across multiple workbooks.<br><br> 2.Collect worksheets from multiple workbooks<br> Sometimes you may need to copy the worksheets of multiple workbooks into one workbook. If there are too many workbooks, it will be time-consuming to do it manually. By this feature, you can do it quickly.<br><br> 3.Collect rows from multiple workbooks<br> ExcelSuite allows you to copy a pre-defined number of rows from multiple workbooks into a single file.<br><br> 4.SUM based on categories<br> Total up categorical data; Add up all data that have the same category. This operation can be implemented across workbooks.<br><br> 5.Merge 2 worksheets by matching values<br> With this feature, you can merge 2 worksheets by matching values. The program matches rows automatically based on the key column, and connect the rows from the two worksheets into one row.<br><br> 6.Get common rows between two worksheets<br> With this feature, you can get common rows between worksheets.<br><br> 7.Remove row if common value in another worksheet<br> It searches duplicated rows by specified key column of two worksheets, and removes rows from worksheet1 if the rows also appear in another worksheet2.<br><br> 8.Check worksheets of the same format<br> By this feature, you can check worksheets based on a template worksheet. These worksheets can exist in single workbook, or across multiple workbooks. What to check: 1) whether the data match the formulas; 2) whether the data type of cells is the same with those in the template worksheet.<br><br>