Collect rows from multiple workbooks

 

By this feature, you can copy rows from multiple workbooks into one worksheet.

 

 

Steps to go:

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

Step 2: 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 3: Specify ‘The first row’. It does it works from this row, ignores previous rows.

Step 4: Specify ‘The last row. It ends its work at this row, ignores later rows. Note: It is counted backwards.

Step 5: Enter ‘Keep formulas in the result’. Normally you can select ‘No’.

Step 6: Click ‘Start’ button.

 

Example:

Let’s say there two sale report of Jack and Tom. The manager wants to a total report for both of them.

 

Jack.xls

Salesman

Product

Quantity

Date

Jack

TV Set

9

2006-1-1

Jack

PC

12

2006-1-4

Jack

Icebox

8

2006-1-9

 

Tom.xls

Salesman

Product

Quantity

Date

Tom

TV Set

5

2006-1-2

Tom

PC

10

2006-1-4

Tom

PC

15

2006-1-7

Tom

Icebox

7

2006-1-9

 

Follow step 1~6:

Step 1: ‘C:\Reports’.

Step 2: ‘*(All worksheets)’.

Step 3: The first row should be 3 because we need to ignore the first row and the second row.

Step 4: The last row is 1 (Counted backwards).

Step 5: Select ‘No’.

Step 6: Click ‘Start’ button.

 

Result:

Jack

TV Set

9

2006-1-1

Jack

PC

12

2006-1-4

Jack

Icebox

8

2006-1-9

Tom

TV Set

5

2006-1-2

Tom

PC

10

2006-1-4

Tom

PC

15

2006-1-7

Tom

Icebox

7

2006-1-9