I need a macro that will add set number of rows between each existing row of data in my spreadsheet. Also the macro needs to allow the data row above the newly added blank rows to be copied into these blank rows. My spreadsheet has 28,000 rows of data that needs to be modified in this manner and I need a quick way to do this.
Any help will be greatly appreciated.
Any help will be greatly appreciated.