Xlsx Macro

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.
example:
ID Text
1 xxxx
2 yyyy
3 zzzz
5 xxxx
7 aaaa

i would like the sheet to look like

ID Text
1 xxxx
2 yyyy
3 zzzz
4
5 xxxx
6
7 aaaa

i would like the macro for future use too along with fixed files

Leave a Reply

Your email address will not be published. Required fields are marked *