Find Jobs
Hire Freelancers

Rearrange and change code in google sheet -- 2

$15-25 USD / hour

Closed
Posted over 5 years ago

$15-25 USD / hour

My company has a simple Google sheet used for staffing of our resources. In addition to cell formulas, there are some macro codes in the sheet for updating the time (weeks that are displayed), and also for sending out mails weekly to each person to ensure they have entered the correct information. Today there is one sheet for entering data, and one sheet used to visualize the resource utilization. I need to rearrange this spreadsheet so that the input and visualization sheet are merged by using collapse / expand functionality. In other words, by using a collapse / expand functionality, I would like the sheet to look like the output sheet when all resources are collapsed, and I want to be able to see and enter new projects by expanding each resource (in a similar way as we can do in the input sheet today)
Project ID: 17805934

About the project

17 proposals
Remote project
Active 5 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
17 freelancers are bidding on average $21 USD/hour for this job
User Avatar
Hello, I have checked your Input and output sheet screenshots and can handle your project. You may review my profile. Thanks
$15 USD in 40 days
4.8 (248 reviews)
7.4
7.4
User Avatar
Hi there, As an Google sheets expert i can help you with this coding project. Please feel free to contact me to discuss further details. Best regards, Miljan
$23 USD in 40 days
4.9 (143 reviews)
7.5
7.5
User Avatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$30 USD in 40 days
4.9 (239 reviews)
6.9
6.9
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
$25 USD in 20 days
4.9 (238 reviews)
6.9
6.9
User Avatar
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.”
$23 USD in 40 days
5.0 (96 reviews)
6.4
6.4
User Avatar
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
$23 USD in 40 days
4.9 (155 reviews)
6.4
6.4
User Avatar
Hello there, as an expert in google sheet and app script, i can help you to accurately rearrange your spreadsheet as you have specified. Please contact me and let us talk more about your project. Thanks
$20 USD in 20 days
4.9 (85 reviews)
5.8
5.8
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc 100% Satisfaction Of Deliverable
$22 USD in 40 days
4.9 (72 reviews)
5.8
5.8
User Avatar
I am based out of Buffalo, NY, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Design/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, Adobe packages, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc.
$15 USD in 1 day
4.8 (80 reviews)
6.0
6.0
User Avatar
Hello Google Sheets is awesome but ages fast. You will get it slowed down more and more as you enter more data . This is because of lack of lazy loading ( Loading all data at once).. We can replicate the functionality in a well designed web app if you want. Please ping us to discuss further.
$22 USD in 40 days
5.0 (30 reviews)
5.7
5.7
User Avatar
Hi - I have been a talent manager myself in a large organisation and have built several utilities like this. While what we used were excel based or a reporting solution with a database back-end and a tool bar front end.. conceptually it is one and the same. Let us discuss at length if you are interested. Am sure web can work together and build something that is a lot useful than what is currently envisioned. Looking forward to hearing from you. Regards,Gana
$24 USD in 25 days
4.9 (27 reviews)
4.8
4.8
User Avatar
I am willing and wanted to make this project to help you out. I can be a good assistant with this type of project. And you can trust me that i will be doing my job greatly.
$22 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already worked on exel, so if you will provide me your requirement I can come up with work load required. Relevant Skills and Experience Php, exel, data processing, MySQL, Java.
$22 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NORWAY
Oslo, Norway
0.0
0
Payment method verified
Member since Sep 19, 2018

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)
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.