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 - https://www.get-digital-help.com/calendar-monthly-view/

    Cross Link - https://www.mrexcel.com/board/…ncrementing-date.1144613/


    Thanks in advance,

    t0ny84

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