1, use vba read all data from TXT file, there are about more than one thousand data, as shown in figure

2, start with # # # for keywords, after the split in the array, and then the keyword # # the _abc + number to each in the form of structure to store
After comparison with excel table data in the diagram below:

3, the excel in the TXT name field, and, if some in the excel, no TXT, filled with yellow cell under the corresponding field

If there are, in the TXT not excel to create a new sheet in the same format in order to fill in the information in the TXT
Strives for the vb program to how to write

CodePudding user response:

The TXT into another Excel table
Compare the two Excel table of contents, use yellow or add new rows,

CodePudding user response:

Only by vba how to solve the data import and possible data loss

CodePudding user response:

435279695 @qq.com data is sent I do see