Snippets

Copy Values And Formulas Between Different Spreadsheets

Copy Values and Formulas Between Spreadsheets

Snippets, Tutorials /

A question on StackOverflow made me realize that there seems to be no method to copy values and formulas between ranges in different spreadsheets.  Using setValues() just transfers values, including the final result of formulas. On the other hand, using setFormulas() just transfers formulas, leaving blank cells that don’t have formulas. If the ranges are

Copy Values and Formulas Between Spreadsheets Read More »