Find Jobs
Hire Freelancers

Google Sheets script needed.

$30-250 USD

Ditutup
Disiarkan 2 bulan yang lalu

$30-250 USD

Dibayar semasa penghantaran
I'm searching for a skilled Google Sheets programmer to two write a simple script. This must be an actual script, nothing else will be accepted. I have a Google sheets with two sheets. Sheet 1 - I have six cells with data which changes monthly (G10-G16). These six cells are run through about 5 formulas, and result in calculations into other cells (H45-H48). Sheet 2 - I want to be able to enter data each month into columns (B2-B8, C2-C8, etc). This data (six cells) would basically be transferred to the six cells in Sheet 1 (G10-G16) where the formulas are located and then the resulting calculation cells would come back to Sheet 2 and be displayed in the same column under where the data was entered (B12-B15, C12-C15, etc). I'd like the results to update live when I change numbers in each of the columns. This must be done in a script format so that as I change number, the calculations update (or a button is pressed to update the calculations). This should take a programmer about 1 hour to script. - **Custom Formulas**: Crafting formulas tailored to manipulate numerical data, ensuring calculations are streamlined and precise. - **Macro Development**: Building powerful, automated macros to process dates and numbers, enhancing efficiency and reliability. **Data Types**: - Our primary focus will be on enhancing the handling and manipulation of numerical data and dates, ensuring a seamless workflow. **Timeline**: The project needs completion within a month, demanding a dedicated and efficient approach. **Ideal Skills and Experience**: - Proficient in Google Sheets programming - Robust experience in developing custom formulas and macros - A knack for handling numerical data and date functions - Ability to deliver under tight deadlines This project offers the exciting opportunity to transform our data processing capabilities. If you're driven by challenges and have expertise in Google Sheets, your skills are precisely what we need.
ID Projek: 37778449

Tentang projek

68 cadangan
Projek jarak jauh
Aktif 26 hari yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
68 pekerja bebas membida secara purata $109 USD untuk pekerjaan ini
Avatar Pengguna
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD dalam 5 hari
4.9 (641 ulasan)
8.6
8.6
Avatar Pengguna
"""""""""""""""""""ADVANCE GOOGLE SHEET & EXCEL EXPERT/GOOGLE SHEET SCRIPT"""""""""""""""""""""""" ""Sir, EXCEL & GOOGLE SHEET are my specialty and I can perform any complex task in THESE. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$99 USD dalam 1 hari
4.9 (276 ulasan)
7.3
7.3
Avatar Pengguna
Building off my extensive experience with complex Excel VBA projects and automation, I have developed a robust command over Google Sheets as well, both in terms of automation and custom formulas. Your project's requirement of transferring data from Sheet 2 to Sheet 1, performing necessary calculations (with live update on demand), and then displaying the resulting values in Sheet 2 again is a perfect match for my expertise. I can confidently say, this task could be easily completed well within an hour. Further, I have a deep-rooted understanding of numerical data manipulation tailored specifically for tasks like yours. Working under tight deadlines has been my forte; however, I never let it compromise the quality of my work. Your project timeline complements perfectly with my approach to deliverables - dedicated and efficient. I am very excited for this project to incorporate your requirements into a seamless workflow. Let us work together to optimize your data management onto another level. Contact me so we can start the journey towards an excellent project!
$140 USD dalam 3 hari
4.9 (412 ulasan)
7.5
7.5
Avatar Pengguna
Hello, I am a proficient Google Sheets expert with extensive experience in spreadsheet management and data analysis. I am excited about the opportunity to assist you with your Google Sheets projects and help streamline your workflows. Key Skills and Experience: Proficiency in Google Sheets, including advanced formulas, functions, and data manipulation techniques. Experience in creating custom spreadsheets for various purposes, such as project tracking, budgeting, and data visualization. Strong organizational skills and attention to detail to ensure accuracy and efficiency in spreadsheet management. Ability to collaborate with team members and stakeholders to understand project requirements and deliver solutions that meet their needs. Familiarity with Google Workspace tools and integration capabilities to enhance productivity and collaboration. I am committed to delivering high-quality results and providing reliable support for your Google Sheets projects. Thank you for considering my bid, and I look forward to the opportunity to work with you. Best regards, Martin Dudumi
$120 USD dalam 1 hari
5.0 (53 ulasan)
6.2
6.2
Avatar Pengguna
Hi, I am interested to work on this task, I am an expert developer with vast experience. Kindly discuss/share details. Thanks and regards. Khalid
$250 USD dalam 10 hari
4.9 (34 ulasan)
5.7
5.7
Avatar Pengguna
Dear Client, I am writing to express my interest in collaborating with you on your project posted in Freelancer. Based on the project details provided, I assure you that I have the skills and expertise required to deliver high-quality work within the specified timeframe. I am confident in my ability to deliver exceptional results for your project. I am committed to maintaining open lines of communication, delivering on time, and ensuring your complete satisfaction. Waiting to hear from you. With thanks regards
$99 USD dalam 2 hari
4.7 (62 ulasan)
5.9
5.9
Avatar Pengguna
With an extensive background as a software developer and data scientist, I am confident in my ability to complete this Google Sheets project successfully. My proficiency in Python, specifically working with data using Pandas and Excel, lends itself perfectly to the task you have described. Over the years, I have honed my skills at manipulating numerical data and crafting custom formulas- both of which are essential to creating the script you require. In line with your timeline, I am committed to a quick turnaround without compromising quality. I understand that reliability and efficiency are essential in delivering projects on time, and I can assure you that those qualities underpin my work ethic. Having worked on similar tasks previously, transforming clients' data processing capabilities, I am poised to leverage this experience to bring about similar positive impact for you. Lastly, it's of note that this project aligns perfectly with my passion for creative problem-solving within tight deadlines. By choosing me, you're picking not just a skilled programmer but also a collaborator who will actively contribute ideas on how best to enhance your google sheet's functionality. Together we can optimize your workflow significantly. Let's get started!
$80 USD dalam 2 hari
5.0 (12 ulasan)
4.8
4.8
Avatar Pengguna
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
$70 USD dalam 1 hari
5.0 (33 ulasan)
4.8
4.8
Avatar Pengguna
Hello sir, I hope you are good. I have read your job description, its doable job as per my experience and knowledge. I want to ask you few questions about job description. I am full stack developer having a good experience in Google Sheets, Excel, Data Processing and Software Architecture. Lets start chat, I assure you that you will get quality work in given time and cost. You can check my portolio as well: https://www.freelancer.com/u/Sidrairfan078 Thanks! Sidra
$155 USD dalam 8 hari
5.0 (2 ulasan)
4.8
4.8
Avatar Pengguna
Drawing from my 12+ years of experience in the domains of MNCs like IBM, Accenture, Amazon, and Google, I am well-versed with the programming complexities of Google Sheets. As your project demands, I bring to the table strong Excel and Google Sheets skills that are accompanied by over a decade's experience in crafting custom formulas and developing automation macros. These proficiencies lend themselves naturally to handling numerical data and date functions, which is the prime focus of your project. Moreover, I understand that deadlines play a pivotal role in projects, and I have a reputation for delivering high-quality work even under tight timelines - something I'm confident about managing to complete within a month for you. Additionally, having extensively worked with entities like Amazon and Google, I have gained a holistic understanding of effective data management and processing - insights which will greatly assist with providing you the solutions you require. More than just completing the task at hand, I see true value in transforming how we process data. Your project offers us both an exciting opportunity to refine our data handling capabilities together. As someone who thrives on challenges and understands exactly what's expected with this project, I assure you my dedication,and expertise; resulting in an elevated user-experience beyond the completion of this crucial script.
$30 USD dalam 1 hari
4.9 (68 ulasan)
4.5
4.5
Avatar Pengguna
"""""""""""""""""""""""""""TOP GOOGLE SHEETS EXPERT"""""""""""""""""""""""""""" Greetings! I clearly understand what is required of the project. I am an GOOGLE SHEETS Advanced Level Expert. I have extensive experience in GOOGLE SHEETS, Excel, particularly in creating DASHBOARD, VLOOKUP, PIVOT FUNCTION, AUTOMATION, CODING and CUSTOM FORMATTING. I am also an expert of FINANCIAL CALCULATIONS and ANALYSIS. This is my field and I can complete this project with in 24 hours with added quality. Please Text me to discuss further. About me I am a Chartered Accountant with many years of experience from one of the worlds big four Accountancy and auditing firm """"""""EARNST & YOUNG FORD RHODES GLOBAL"""""""". I have also worked in PWC Audit Firm. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards, Spogmai Kakar"""
$45 USD dalam 1 hari
5.0 (27 ulasan)
4.1
4.1
Avatar Pengguna
Hi there, I am a Data Scientist a professional responsible for extracting actionable insights and knowledge from large volumes of data GOOGLE SHEET Development. I can write clean Google Sheets, Google Excel Sheets, Power BI, Outlook, and Google VBA macros. Google Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate, and professional results, building trust and a long-term relationship with customers is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev
$140 USD dalam 7 hari
5.0 (9 ulasan)
4.0
4.0
Avatar Pengguna
To efficiently develop the script that automates the data transfer and calculation updates between Sheet 1 and Sheet 2 in your Google Sheets, I'll need access to the specific sheet in question. With the necessary access, I can craft a Google Apps Script that seamlessly transfers the monthly data you input on Sheet 2 (B2-B8, C2-C8, etc.) to the corresponding cells in Sheet 1 (G10-G16), processes the calculations, and then displays the results back on Sheet 2 under the respective columns (B12-B15, C12-C15, etc.). This script will ensure that the results update live as you modify the input data or can incorporate a button to refresh the calculations, as per your preference. I can have this script ready for you in about 30 minutes once I have access to the sheet. Could you please provide me with the necessary permissions to access and edit your Google Sheet? This will enable me to start scripting the solution right away. You can award the project once you are happy with my deliverables. Looking forward to working with you
$100 USD dalam 1 hari
4.9 (11 ulasan)
4.3
4.3
Avatar Pengguna
Hi, I hope this message finds you well. With over 15 years of full stack development expertise, I'm eager to bring your project to life. My experience ensures precision, efficiency, and a keen understanding of your needs. I'm committed to delivering top-notch quality and unwavering support, ensuring your project's success within your timeline. If you'd like to review my past work, I'm ready to share my portfolio. Let's discuss your project further. I'm here to help. Best regards
$140 USD dalam 7 hari
4.9 (4 ulasan)
3.8
3.8
Avatar Pengguna
Hi, I am interested in this project and i am ready to do it for you. To proceed further, I am ready to discuss your project and start immediately. Thanks
$140 USD dalam 3 hari
4.6 (24 ulasan)
3.9
3.9
Avatar Pengguna
Hello With Excel expertise and Finance background I am right choice for this job. I read your job requirements and I am confident that I can do this Job with professional look. I can assure you the spreadsheet format will be simple and professional, Contact with me
$50 USD dalam 1 hari
5.0 (12 ulasan)
3.6
3.6
Avatar Pengguna
I saw your job description I can do this project perfectly. Lets discuss it in more over the chat. Thanks
$50 USD dalam 3 hari
5.0 (15 ulasan)
3.7
3.7
Avatar Pengguna
Hello Sir/Mam I am expert on Google Sheet Script I can do your task with 100% accuracy. I have good Experience about your task. I have reviewed your project brief carefully and would like to assist you with the task. I am ready to give you a free sample for assessment. if you are interested please knock Thanks
$40 USD dalam 2 hari
5.0 (19 ulasan)
3.0
3.0
Avatar Pengguna
As a seasoned Google Sheets programmer with over 50 successful projects under my belt, I have the precise skills you require to complete the task at hand. I specialize in crafting tailor-made formulas that ensure numerical data is handled efficiently and accurately. Additionally, my expertise in creating powerful macros will play a vital role in streamlining your data processing and enhancing your workflow. With this project, we're diving into an exciting phase where we can transform your data handling capabilities for the better. Your described timeline for completion fit well within my efficient work practices, ensuring that we won't be compromising on quality for speed. Choosing me for this project means selecting experience, expertise, and a promise of dedicated craftsmanship. Let's leverage the full potential of Google Sheets to make your data handling smooth and seamless. Looking forward to helping you tackle this challenge head-on!
$90 USD dalam 2 hari
4.7 (11 ulasan)
3.4
3.4
Avatar Pengguna
Greetings, I am an experienced Google Sheets programmer excited to take on your project. I understand the requirements for creating a script that seamlessly transfers data between Sheet 1 and Sheet 2, ensuring live updates of calculations as numbers are changed. With my expertise in crafting custom formulas and developing macros tailored to streamline data manipulation, I am confident in delivering a robust solution within the specified timeline. My proficiency in handling numerical data and date functions, coupled with a dedication to meeting tight deadlines, positions me as the ideal candidate to enhance your data processing capabilities. I look forward to the opportunity to contribute to the success of your project. Sincerely, Muzafar
$30 USD dalam 1 hari
4.9 (5 ulasan)
3.1
3.1

Tentang klien

Bendera UNITED STATES
United States
5.0
1
Kaedah pembayaran disahkan
Ahli sejak Nov 30, 2016

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.