Insert X Rows To Table & Increment Date In Cell

  • I am currently in the process of trying to customise a Calendar Template (link below).

    The workbook has two sheets:

    Sheet 1 - Calendar (Front End)

    Sheet 2 - Schedule

    On Sheet 1 there is an Add Event button which allows users to enter in a Date and Event Name which is then added as a new row to a table on Sheet 2. What I am trying to do is to add the ability to do recurring entries such as Fortnightly and Monthly.

    Current Add Button Code

    I found the below thread on this forum which has the same concept that I want but I am unable to get it to work properly. Is there anyone who might know if this is possible and if so what code I would use?

    Insert New Row & Increment Number

    Calendar Template -

    Cross Link -…ncrementing-date.1144613/

    Thanks in advance,


  • Update - After learning more about LOOPS I was able to mash together the following code (if it might help someone in the future)