Publisher :UtaSoft Date added : 05-Aug-2009 Rating : File size :
Unknown
Language :
English
License :
Shareware - Time Limit
Price : $199.00 OS :
Windows 98/NT/2000/ME/XP/VISTA
UpdateDate : 10-Aug-2009 Requirements :
No special requirements
ExcelSuite's Information
ExcelSuite is a great software to process data across numerous Excel workbooks
1.Add up the same cell across worksheets
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.
2.Collect worksheets from multiple workbooks
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.
3.Collect rows from multiple workbooks
By this feature, you can copy rows from multiple workbooks into one worksheet.
4.SUM based on categories
Total up categorical data; Add up all data that have the same category. This operation can be implemented across workbooks.
5.Merge 2 worksheets by matching values
By 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.
6.Get common rows between two worksheets
By this feature, you can get common rows between worksheets.
7.Remove row if common value in another worksheet
It searches duplicated rows by specified key column of two worksheets, and removes rows from worksheet1 if the rows also appear in another worksheet2.
8.Check worksheets of the same format
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.
Rating :
ExcelSuite is a great software to process data across numerous Excel workbooks
1.Add up the same cell across worksheets
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.
2.Collect worksheets from multiple workbooks
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.
3.Collect rows from multiple workbooks
By this feature, you can copy rows from multiple workbooks into one worksheet.
4.SUM based on categories
Total up categorical data; Add up all data that have the same category. This operation can be implemented across workbooks.
5.Merge 2 worksheets by matching values
By 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.
6.Get common rows between two worksheets
By this feature, you can get common rows between worksheets.
7.Remove row if common value in another worksheet
It searches duplicated rows by specified key column of two worksheets, and removes rows from worksheet1 if the rows also appear in another worksheet2.
8.Check worksheets of the same format
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.
Copyright (c) 2007-2009 SharewareOrder.com Inc. All Right reserved.
Copyright (c) 2007-2009 SharewareOrder.com Inc. All Right reserved.
