ExcelSuite 5.0
xcelSuite provides a bunch of useful features for you to process Excel worksheets across workbooks. How to merge spreadsheets? That's it!<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 t
