I have a sample spreadsheet.
I need a macro that inserts a blank row between the header row and the predfined count row when a row is deleted. It should be inserted after the last row of data.
I have very limited knowledge of macros and usually google my way through but Im stuck on how to do this.
If row 2 in the spreasheet was to be deleted by the user then I need a macro that can either:
1/ Adds a new blank row automatically or
2/ Can add a row if the user presses a button.
3/ Must add the new blank row after the row that still contains data.
Any assistance is greatly appreciatted.