ExcelSuite
v5.0ExcelSuite provides a bunch of useful features for you to merge Excel spreadsheets<br><br> 1.Add up the same cell across worksheets<br> 2.Collect worksheets from multiple workbooks<br> 3.Collect rows...
Description
ExcelSuite 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 the data type of cells is the same with those in the template worksheet.<br /><br />
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 the data type of cells is the same with those in the template worksheet.<br /><br />
