I have 2 Google spreadsheets:
1- The main spreadsheet
2- The secondary spreadsheet
I want to copy one row from the main spreadsheet to the secondary spreadsheet with the same style and formatting.
1- The style must be kept.
2- The row must be added in the Botton of the secondary sheet.
3- the main spreadsheet and the secondary spread sheet are different documents.