I am looking at importing a file that could have up to 1000 populated lines in it. there will be no empty rows in between the lines. I then need to ensure that there are 10 empty rows inserted in between every populated row. I was thinking of doing it manually and recording it on a macro.... However the issue will have with this is that everyday the number of rows will vary.
is there anyway of auto inserting 10 empty rows in between populated ones?