The title speaks for itself. I am looking to do two things in Google Sheets, because I am entering data from a different third-party app using Google API.
I need Google Sheets to auto sort a column I specify with it's rows. So for example, this:
| A | B ===================== 1 | This is | 22 2 | Is | 33 3 | A Test | 44
Should look like this when sorting column A:
| A | B ===================== 1 | A Test | 44 2 | Is | 33 3 | This is | 22
I have 7 sheets in the same workbook and they all carry the same format and data type. I want them to be automatically copied (duplicated) as is to an 8th sheet, so whenever I add any data in, for example, sheet 1, it automatically be add to the last sheet, which will be containing all the data from all the sheets in the workbook.
I hope that I am clear enough.