Adding a Blank Row Every Nth Row in a Table

[rachelfish96]

Hello, so I'm using VBA to make accounting easier. I created a UserForm where I enter in data and it posts to a table in the sheet. I want to make it neater so I want to add a blank row after every 2 rows (whenever I press the submit button from the Userform). The 2 rows consist of double-entry accounting, and I want every 3rd row to be blank, so sort of like a loop. The trick is that I want the loop to be contained in the table. The 3rd row of the sheet is not necessarily the 3rd row in the table. I am a complete beginner in VBA and have been looking at Youtube tutorials but I haven't been able to solve this problem. Would appreciate any kind of help (even if it means you telling me that it's not possible). Thank you!

My coding so far for the "Submit button" looks like this. The target row is set to be the last row of the table. B3:H3 are the table headers.

Please Login or Register  to view this content.

[rachelfish96]

Here's an update to my formula.

Please Login or Register  to view this content.