1

The following is offered on the basis that there are usually many ways to solve a problem. This is just one approach. There are three elements to the resolution of this question: 1 - update the data in columns columns A-to-G This is achieved through a virtual "copy/paste" using copyValuesToRange(sheet, column, columnEnd, row, rowEnd) doc ref. 2 - set the ...


1

If the macro is created by you then it is totally safe. The warning is general eg. it doesn't differentiate if the macro was created by you or by someone else. The whole procedure is just safety protocol designed to give a user "more control" over possibly malicious (in case you run unknown macro) action. Same happens when you try to add a custom script to ...


Only top voted, non community-wiki answers of a minimum length are eligible