As shown in figure, the files according to the first column of subtotals for dividing line, namely, from start to hit the first small meter check (including the subtotal) as a file, after subtotal recount, until the end of the file traversal

CodePudding user response:

According to the work of "column 1" in the table a judgment text content,
Keep "new workbook, copy the data, the specified filename to save, close just a new workbook", not to go?

There is no complex logic, this how difficult...

CodePudding user response:

You can baidu under VB excel,
This is the key to the operation of the excel, the other is traversed - "writing,