This script allows to search a particular value, once find it, a new row will be inserted above or below.

 

When I use the script ?

When I need to insert a row for a specific value.

 

How to create the script ?

Read How to create, edit and select an Office Script in an excel report

 

How to create the button to associate it with the script ?

Read How to create a button and associated it to an Office Script in an excel report

 

How is/are the script(s) ?

Copy the code below and paste it into your script. You will see my comments in green if exist so follow the help to adapt to your need.

function main(workbook: ExcelScript.Workbook) {
  //change sheet1 by yours
  let sheet = workbook.getWorksheet('Sheet1');
  //change C1 by yours
  let columnC = sheet.getRange("C1").getEntireColumn().getUsedRange();
  let value = columnC.getValues();
    for (let i = value.length - 1; i >= 0; i--) {
	  //change the word yes to find by yours
      if (value[i][0] == "yes") {
	    //to insert the row below, change (i, 0) by (i+1, 0)           
	    let fcelldp = sheet.getCell(i, 0).getAddress();
        sheet.getRange(`${fcelldp}`).getEntireRow().insert(ExcelScript.InsertShiftDirection.down);
	  }
    }
}