I have a sheet with a lot of columns with data and formulas. I need to insert a new row with the same formulas as the last row by clicking on a button. How can I do this?
-
Can you explain why you need a button instead of copying and pasting the row? A button will likely require a Google Apps Script which will make it much more complicated.– Blind SpotsMay 18 at 13:07
-
Also, please edit your question to clarify what the last row means. For example, last row containing data? Last row in spreadsheet? Should the button be adding a new row to the sheet?– Blind SpotsMay 18 at 13:15
-
see possible duplicate webapps.stackexchange.com/questions/47171/…– Blind SpotsMay 21 at 15:47
Add a comment
|