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