Closed

GOOGLE SPREADSHEET AUTOMATIC CELL REARRANGEMENT

I HAVE 2 BLOCKS OF CELLS

(A3:A21 , M3:M21) AND (A22:A39 , M22:M3)

EACH BLOCK OF CELLS HAS A J CELL WHICH CONTAINS DATA.

THE DATA IS ALWAYS UPDATING EVERY 20 MINUTES.

I NEED THE DATA TO BE SORTED LOW TO HIGH.

THE NUMBER CLOSER TO ZERO AT THE TOP OF THE LIST AND OF COURSE THE DATA FURTHER AWAY AT BOTTOM OF LIST.

BUT I NEED THE J CELL TO TAKE ALL THE OTHER CELLS WITHIN ITS BLOCK TO MOVE WITH IT.

EG-

(A3:A21 , M2 :M21) - JCELL = 35

(A22:A39, M22:M39) - J CELL = 10

THEN CELLS (A22:A39 , M22:M39) MOVE TO (A3:A21 , M3:M21)

Skills: Data Entry, Google Sheets, Excel

See more: php mysql data google spreadsheet, google spreadsheet functions manual, google spreadsheet data entry, google finance google spreadsheet, php form google spreadsheet, google docs automatic invoices, use google spreadsheet access table, google spreadsheet access table, commands google spreadsheet finance, manuale per google spreadsheet, sent email google spreadsheet change cell, current cell google spreadsheet script, google spreadsheet script get cell value, google spreadsheet link to cell in another sheet, updating cell values based on selection in drop down list in google spreadsheet, google spreadsheet query where cell value, google spreadsheet javascript get cell value, send notification email if a cell is changed in google spreadsheet, attach file to google spreadsheet cell, google sheets if cell contains text then return value in another cell

About the Employer:
( 1 review ) LONDON, United Kingdom

Project ID: #28332307

21 freelancers are bidding on average £24 for this job

(976 Reviews)
8.1
writingapp

Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day

£30 GBP in 1 day
(68 Reviews)
5.5
tushchak0716

Hi greetings from Tushar!! I am interested in taking up your project of sorting your google sheet data from low to high. I have hands on experience of working with google app script, google sheet and google forms and More

£15 GBP in 1 day
(8 Reviews)
4.7
manibhai833

Hi I read the task details I am MS Excel Certified professional from MS. I am willing to comlete this task. Come inbox.

£20 GBP in 1 day
(5 Reviews)
3.7
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per More

£30 GBP in 1 day
(12 Reviews)
3.0
AnuradhaVM

Hi, Greetings! ✅checked your project details. I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data entry, Data analysis and MIS Management. I have strong google sheet and Excel skills and am a More

£20 GBP in 7 days
(4 Reviews)
2.7
aruls1962

I have developed a number of systems in Google Sheets. I'm an engineer with 35 years of experience and 7 years in Google sheets Pl. share a copy of the data for study. Pl. tell me how is the data in J cell updated ev More

£10 GBP in 1 day
(3 Reviews)
2.0
engindeveci

I can deliver app the script code to sort the rows in a day. thanks........

£42 GBP in 1 day
(0 Reviews)
0.0
malahfreelancer

Dear Sir/Madam, I'm interested on this project. My fee is GBP20 per day (8 hours). Kindly contact me. Thank you

£20 GBP in 1 day
(0 Reviews)
0.0
Amirahharithah

Hello GOOGLE SPREADSHEET AUTOMATIC CELL REARRANGEMENT I am the person that you are looking for. I have experience in data entry for three years. Since I have studied in Degree in Marketing before, data entry and excel More

£15 GBP in 7 days
(0 Reviews)
0.0
hasan321262165

Dear hiring manager, I am a expert [login to view URL] three years [login to view URL] i see your project description.I can to do best quality in this project.I am a perfect for this project. I will do data entry,exel,g More

£10 GBP in 5 days
(0 Reviews)
0.0
aidamia

Hi, Data entry is my expertise and excel is one of my skills. I also skilled in using google sheets. The project is very simple and I can finished the work within the set timelines with 100% accuracy. Feel free to co More

£18 GBP in 2 days
(0 Reviews)
0.0
MahfujurNime

Hello there, Hope you are doing well. I read your description. I understand your requirements. I will be able to satisfy your requirement. I am a very hard working freelancer and can work effectively as fast as I can More

£10 GBP in 1 day
(0 Reviews)
0.0
kelmenditaulant

To whom it may concern, My field of study is Financial Math and furthermore i work in a bank in department of risk, also i'm certified in excel as advanced knowledge. Best regard, Taulant.

£100 GBP in 2 days
(0 Reviews)
0.0
foysalstk

your need vote service or pulicity service . which service you want to buy say me fast . then let you know our rate and pakages price . you get here all social media service

£11 GBP in 5 days
(0 Reviews)
0.0
tahirmunir787

HELLO GOOD DAY Thank you for reading my response to your project. I understand your project. I I will deliver to you within the time. Regards, Tahir Munir

£10 GBP in 2 days
(0 Reviews)
0.0
sachinkumargowda

if you give your job then 100% perfect work will be done. don't think to much to give. faith is most expensive thing and I can surely afford it ?

£16 GBP in 1 day
(0 Reviews)
0.0
HHATOUM1

Need to know more about the nature of data and it's source and will be ready to move on in application towards successful data organization as per requirement.

£20 GBP in 1 day
(0 Reviews)
0.0
mustafacali

Hi, I'm Mustafa. I can create a sort module in Excel VBA for your project. Please send me a message to discuss. Best regards.

£10 GBP in 1 day
(1 Review)
0.0
ambreen308

Hello, I have gone through your requirement. I am expert in google sheet. Can do the task quickly for you. Looking forward to work with you. Regards, Ambreen Khan

£10 GBP in 7 days
(0 Reviews)
0.0