This script is to check and compare each cell of a specific column to find the current date. If it is found, it copies and pastes as values a range of formula cells of the same row.

 

When I use the script ?

When I have to copy and paste a row of cell range based on the current date.

 

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.

Before to create the script, I will add a new column called “day” in my table with this formula in C2 that will give me the day of the month:

The reason for that is that using the script to compare a date, I need to provide an unique value in text format (not in date format). Now copy the code below:

function main(workbook: ExcelScript.Workbook) {
  // change Sheet1 by yours
  let sheet = workbook.getWorksheet('Sheet1');
  // change C1 by yours
  let row_count = sheet.getRange("C1").getEntireColumn().getUsedRange().getRowCount();
  let rng = sheet.getUsedRange().getValues();
  let cdate = new Date().getDate();
  // change 1 if the start checking line not row 2
  for (let i = 1; i < row_count; i++) {
    // change 2 if not column C
    if (rng[i][2] == cdate) {
      // change 3 (column D) and 5 (column F) by yours
      let firstcell = sheet.getCell(i, 3).getAddress();
      let lastcell = sheet.getCell(i, 5).getAddress();
      sheet.getCell(i, 3).copyFrom(`${firstcell}:${lastcell}`, ExcelScript.RangeCopyType.values);
	}
  }
}