i have 3 worksheets in xlsx.
Each should have 60629 rows.
each one has 2 columns ID and text
there are missing ID rows.
i need macro insert missing ID rows with ID number and that row under text will be empty.
i would like the sheet to look like
i would like the macro for future use too along with fixed files