Excel Report Rollup Assistant 2.0 Green Special Edition _ Common Tools

Operating Environment Windows 98 and above
Sharing software in licensing mode
Software type System Tools
Software size 766.38K

The Excel Rollup Assistant can quickly summarize multiple Excel files in the same format, helping you easily summarize reports from daily, monthly, quarterly, annual, or subordinate units, greatly improving your productivity. It is easy to use and can be used in 5 minutes. Welcome to use!

Excel Rollup Assistant Usage Instructions

1 function and use steps
The Excel Rollup Assistant can summarize or combine data from multiple Excel files in the same format to the corresponding cells, greatly improving your productivity and freeing you from heavy manual rollup, merging work
Step two: In this Drop-down list, select the table you want to summarize. You can select multiple tables.
Step three: Click in the table with the mouse to select the cells you want to summarize. Click again with the mouse, the selected unit will be cleared. (Hint: You can click the "Load from Excel File ..." button to select an existing Excel file in which all the number cells in this Excel file are selected.) This applies to a larger number of cells that you want to summarize. ）
First step: Select the directory where the data files reside. All the Excel files below this directory will be summarized. (Hint: You can also use the "Single file ..." on the right.) button to select a single file. This is used to summarize the situation of multiple tables in a single file)
Fourth step: Click the "Totals" or "merge" button to start the summary or merge. In the process, if necessary, you can press the Stop button to cancel the task.

2 Data File Checksum
In order to ensure that the summary results are correct, before the summary, the program will be summarized in the XLS files are checked, do not meet the requirements of the file will not be summarized to the final results. If there is a failure report after the rollup is completed, there are usually several scenarios:
1 The program did not find the table that you specified in step 2nd.
2 you specify the cells to be counted in the template file, but there is no data in the corresponding cells in the XLS file you want to summarize.
If you do not meet the requirements of XLS files, will output error list, you can click with the mouse to see the details of the information, according to the prompts, modify XLS files, and then a summary.

http://ishare.sina.com.cn/cgi-bin/fileid.cgi?fileid=1346274