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.

 

 

Steps to go:

Step 1: Specify template worksheet. The program checks other worksheets based on the template worksheet. If there is a formula in a cell of template worksheet, it will check if the same cells of other worksheets meet the formula. It will also check if a cell has the same data type with the same cell of the template worksheet.

Step 2: Enter ‘Folder where the Excel files locate’. The application will process all Excel files in this folder (Include subfolder).

Step 3: Enter ‘Worksheets to process’ to specify which worksheets should be process. You enter multiple worksheets name separated by ‘;’. You can enter wildcard here (‘*Sheet’ or ‘Sheet*’).

            Step 4: Click ‘Start’ button.

 

Example:

Let’s say you have sales-costs worksheets of L.A. branch and N.Y. branch. You want to check if there is any error in the worksheets.

 

Los Angeles branch sales-costs in 2006
	Q1	Q2	Q3	Q4	Total
sales	1500	2500	3500	4500	12000
costs	500	500	500	500	2100

 

New York branch sales-costs in 2006
	Q1	Q2	Q3	Q4	Total
sales	1000	2000	3000	4000	10000
costs	500	500	500	500	2000

 

Here is the template worksheet. There are two formulas:

Total sales = Q1 + Q2 + Q3 + Q4

Total costs = Q1 + Q2 + Q3 + Q4

Template worksheet
	Q1	Q2	Q3	Q4	Total
sales	1	1	1	1	1
costs	1	1	1	1	1

 

Follow step 1~4, the program shows below result:

 

In the first line, it says that some errors were found. Clicking this line, it will show detailed information in below window:

 

As you can see, there is an error in the worksheet of L.A. branch. Total costs should be 2,000 instead of 2,100.

 

You can check hundreds of worksheets this way, quickly and easily.