I have a village hall booking system in Google Sheets, operating from google forms. I have a single row for each booking. When an enquiry says ‘yes’ to recurrence, I want to duplicate some details in the sheet to create further booking rows. I have a cell which calculates the number of bookings based on the dates/frequency.