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.