Find Jobs
Hire Freelancers

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

$10-30 USD

Completed
Posted almost 9 years ago

$10-30 USD

Paid on delivery
*** 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.
Project ID: 7365147

About the project

1 proposal
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
5.0 (4 reviews)
1.0
1.0
1 freelancer is bidding on average $20 USD for this job
User Avatar
please send the data .
$30 USD in 1 day
5.0 (8 reviews)
2.5
2.5

About the client

Flag of UNITED STATES
Arlington, United States
5.0
3
Payment method verified
Member since Feb 9, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.