I have a spreadsheet with bank transactions and want to insert a blank row every time the date in column A changes. Can someone help me write a macro to do this? Thanks!
Hi Marvin Here is something that might work although you should try it out on a copy of your workbook.
Sub AddRow() NoRows = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To NoRows If Cells(i, 1) <> Cells(i - 1, 1) And Cells(i, 1) <> "" And Cells(i - 1, 1) <> "" Then Cells(i, 1).EntireRow.Insert i = i + 1 End If Next End Sub
