Auto sort a column and auto duplicate all sheets to one sheet

$10-30 USD

Slutfört

Publicerad

ungefär nio år sedan

$10-30 USD

Betalning vid leverans

*** THIS PROJECT IS FOR GOOGLE SPREADSHEET ONLY *** 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. First: 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 (automatically): | A | B ===================== 1 | A Test | 44 2 | Is | 33 3 | This is | 22 Second: 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. Sheet 1 comes at top then sheet 2 under it and so forth. I just need the way to do it. No need for anything else. I hope that I am clear enough.

Excel

Project ID: 7365147

Om projektet

1 anbud

Distansprojekt

Senaste aktivitet nio år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@swatiag1101

Hi there, I understand clearly the two things you need on your Google Spreadsheet, that is auto sort of all columns when first column is sorted, and auto updating of the last sheet whenever any of the seven sheets are updated. I'll send you a sample Google Spreadsheet where I will do these two things, and then you can use the logic I used for your sheet. Or, I could do it for you. Regards, Swati

$20 USD Om 1 dag