ExcelSuite provides a bunch of useful features for you to process and merge multiple worksheets
of the same format across workbooks.
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
and add up the same cell across worksheets.
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. ExcelSuite will collect worksheets from multiple workbooks for you and
you can do it quickly.
- Windows 8/7/XP/Vista
- 256 MB RAM
|License:||Free to try, $39.00 to buy|
Key Features of ExcelSuite:
- 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.
- 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.
- Collect rows from multiple workbooks
With this feature, you can copy a pre-defined number of rows from multiple workbooks into a single worksheet.
- SUM based on categories
Total up categorical data; Add up all data that have the same category. This operation can be implemented
- Merge 2 worksheets by matching values
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.
- Get common rows between two worksheets
With this feature, you can get common rows between worksheets.
- 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.
- Check worksheets of the same format
With 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.
| RELATED SOFTWARE DOWNLOADS FOR EXCELSUITE
- ExcelSmartTools DataClean
It is developed for helping users to import and link Microsoft tables and queries to Excel worksheets...
- menuZap for Excel
The innovative menuZap menu dialog box empowers the way you manage and select your worksheets through a menu dialog box.
- COMxL RS232C
is an ease-to-use and very-helpful Add-Ons/Add-Ins for MS Excel 97/2000 's user.
- Vocabulary Worksheet Factory
lmprove and reinforce the vocabulary skills of your students with challenging and motivating worksheet activities created with Vocabulary Worksheet Factory
- Worksheet Booster
improves the speed required to accomplish routine operations with Excel worksheets
- Worksheet Search Excel add-in
is a Microsoft Excel add-in that helps to find a certain sheet in a workbook that contains a wide range of sheets
- Excel Quick Search
is an Microsoft Excel plugin. Automatic filtration of worksheet rows which contain the required text.
- Spreadsheet Goal Seeker
allowing you to apply it to many cells at one time, simply configuring the Spreadsheet Goal Seeker's wizard.
- JEM Plus (Excel Add-in)
It is an unbelievable product that will boost productivity and take data integrity to new heights.
- 4TOPS Excel Import Assistant for MS Access 2000
is an Access add-in for importing excel into access in a controlled way
- Excel Invoice Manager Platinum
is an electronic invoice software and billing software based on Excel templates and add-in.
- GTD Excel Report Server
GTD Excel Report Server is implemented as a Web service that provides an optimized and parallel processing infrastructure for processing and rendering reports.