Ask: can I have read in circulation way out multiple data in a text file, and each one can be data can be written to the corresponding text box, to EXCEL in the template to fill in is ready now, the problem is that the first line of the template and the second row have calculation formula, the last line of the template have calculation formula, but I am the number of data, there might be 1 ~ 2 two lines, there may be 100 ~ 200 lines, how to make the last line of the EXCEL template as the amount of data on the number of how many lifting line?
For example: the template of the first and second lines have a calculation formula of the third line began to fill in the data read from TXT file, such as the five data, so, there is the last line of the template in line 8, and calculate the total number of 3 ~ 7 lines of data; Article 10 data, then there is the last line of the template in line 13, and calculate the total number of 3 ~ 12 lines of data,

CodePudding user response:

Using insert,

Specific code, you can actually get VBA in Excel interface by record macro code, ported to VB,

CodePudding user response:

So, first you have to come to the conclusion that the rule, right?