I will parse an XML file and export it to Excel. However, for large XML files that exceed Excel's row limit, I will split them into multiple Excel files based on the row count. Here’s the issue: the "Line Number Counter" column represents each entry. If I set the row limit to 300,000, and the last entry finishes on the 300,001st row, I want the new Excel file to start without splitting the entry. For example, if there are 3 rows for an entry starting after the 299,998th row and finishing on the 300,001st row, I want this entry to be written to the second Excel file. I need to automate this process using a macro. Could you help with that?
