Hey,
I am currently working on a spreadsheet which I have to add 2 rows every 44th row.
I would like to insert 2 rows between rows 29 and 30. The first row has to contain data but the second added row is meant to stay blank (although it would require to maintain the formatting)
On the first row to be added, the data is
Column A - Blank
Column B - Fatal Issue (Yes/No)
Column C - Drop down list linked to sheet 1 (called '1. Criteria', the cells in the list are B66 and B67)
Column D - If Yes, explain it in the Comments section
I need these rows inserted every 44th row (so, the first two rows will be inserted between rows 29 and 30, the second two rows will be inserted between 73 and 74 the third between 117 and 118 and so on for about 5000 rows but I will have to add more data later on, so it will probably get up to 10000).
I assume a macro could do this, but I have zero skills. Could anyone help me out with this issue? ANy help would be greatly appreciated.
Bookmarks