Find Jobs
Hire Freelancers

Google Sheets Expert Needed

$10-30 AUD

Completed
Posted about 1 month ago

$10-30 AUD

Paid on delivery
We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explaining fully and showing the docs.
Project ID: 37958612

About the project

66 proposals
Remote project
Active 1 mo 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
Hello, I am a Google Sheets expert and I can help you right away. Please check my profile and contact me to discuss further details. Regards.
$50 AUD in 1 day
5.0 (518 reviews)
8.1
8.1
66 freelancers are bidding on average $23 AUD for this job
User Avatar
Hi, this is definitely possible. This can be quickly done with both script and formulas. If you are interested, feel free to share the video that you mentioned and i will take a look. I am available right now. Thanks, Milan
$25 AUD in 1 day
5.0 (809 reviews)
7.6
7.6
User Avatar
Hello Honor Good day, I've worked on similar projects with excellent results. 10 Years of Professionalism and experience specified. So That I have a straightforward way to complete the project and deliver quality notes to tight deadlines. You can see an example of one of those projects in my portfolio here: www.freelancer.com/u/oadsmedia I'll be sure to provide you with Quality work according to your instructions. Please Award me the project so we can discuss it and start it now. With Best Regards! Joni D
$30 AUD in 1 day
5.0 (102 reviews)
6.9
6.9
User Avatar
Hi There, Ready right now I'm ready for Google Sheets task. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer
$15 AUD in 1 day
4.8 (180 reviews)
6.4
6.4
User Avatar
Dear Project Manager, The task seems simple to lookup the sales rep from sheet1 into sheet2 but using a script. Happy to offer you, my support. If interested in availing my support, feel free to reach out and discuss Regards MM
$50 AUD in 1 day
5.0 (6 reviews)
4.8
4.8
User Avatar
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
$20 AUD in 1 day
5.0 (25 reviews)
4.7
4.7
User Avatar
Hi there! I am expert in MS-Excel and can write a script for you to do your required task. Let me know if you are interested. Regards!
$30 AUD in 1 day
5.0 (21 reviews)
4.3
4.3
User Avatar
With over 6 years of experience as a virtual assistant and my strong background in finance and data management, I am confident that I can excel in your project that revolves around your Google Sheets and Excel needs. My expertise encompasses various data related tasks such as data entry, processing, data collection, and the utilization of MS Excel for reporting purposes. In addition to that, I am also adept at translating languages, which can come in handy given our project may require some data with different languages. Speaking specifically to your project, I have paid acute attention to detail where data integrity is concerned. This will be a crucial element as we filter and match customer names to their respective sales rep. With the introduction of new sheets on a weekly basis containing payment data, accuracy is of utmost importance. Therefore my good typing speed (50 wpm) will definitely play a significant role in delivering quality results in a timely manner. Lastly, my adaptability is a key virtue. Whether it’s navigating through new software or mastering efficient ways to handle bulk data, I'm ready to learn any tools you prefer to highlight the unique needs of your project. Pairing my skills with your vision, we can create an automated process that saves you time and improves your productivity. Let's get started!
$30 AUD in 1 day
4.9 (15 reviews)
3.9
3.9
User Avatar
Hello there, I have experience in Google Sheets i can match the customer name in the new sheet with the rep and insert the sales rep's name in a new column, it's a pleasure to discuss in chat I can start now.
$30 AUD in 1 day
5.0 (7 reviews)
3.4
3.4
User Avatar
My name is Kath, a dedicated and keen-to-details freelancer, eager to kick start my career in customer support industry. While I may not possess direct work experience in the field, my passion for accuracy and timeliness while being efficient, puts me as the ideal candidate for a customer support role. I am able to perform independently, and can also work with a team, coming from my experience in my previous job and little exposure to our family business before. Those experiences contribute to my understanding of how important it is to be responsive and responsible, which are key attributes of an ideal customer service support representative. I am thrilled to join your team and/or company to leverage these skills and experience, and help you achieve your goal by becoming a reliable asset to the company. Eager to secure entry-level jobs for: Customer service Data entry Admin tasks Virtual assistance Email handling
$20 AUD in 3 days
5.0 (2 reviews)
3.2
3.2
User Avatar
Hello, I think Iam not late to bid on this project so I am expert in excel and google spreadsheet also. I am currently working as a Data Manager in a reputable company and I am ready to start this project immediately. Looking forward to your response.
$20 AUD in 1 day
4.9 (2 reviews)
2.1
2.1
User Avatar
Hello I can do that with a script or a plug in as you will share the detail I'll chose the best option for you or let you choose whatever method you'll think we'll go ahead with that. As I have worked for more than 2 year on Google sheet for a client arranging data same like yours so I can do this project for you as you have a tight schedule I can do this project quickly efficiently. If you have any questions or want to interview me. I'll be available for that. Regards Muntazir mehdi
$20 AUD in 1 day
5.0 (2 reviews)
1.8
1.8
User Avatar
G'day rist: 1. First, we need to create a formula that can count the number of cells in a specific column that contain a certain word or phrase. This will help us track certain data points in our sheet. 2. Next, we need to create a conditional formatting rule that will highlight cells in a specific column if they contain a certain word or phrase. This will help us quickly identify any important data in our sheet. 3. We also need to create a drop-down menu in a specific cell that will allow us to filter our sheet by a certain criteria. This will make it easier for us to view and analyze specific data points. 4. Additionally, we need to create a formula that can check if a cell in a certain column is empty or not. If it is empty, we want the formula to return a specific value, and if it is not empty, we want it to return a different value. This will help us keep our sheet organized and easily identify any missing data. 5. Finally, we need to create a dashboard tab that will pull data from our sheet and display it in a visually appealing format. This will help us easily see trends and patterns in our data without having to manually sift through the entire sheet. If you are a google sheets / excel expert, please apply for this project and include examples of similar projects you have completed in the past. Thank you! Best regards, Giáp Văn Hưng
$28 AUD in 7 days
4.4 (2 reviews)
1.7
1.7
User Avatar
"Hi sir , I'm an Expert Providing Services of Visual Basic Data Processing Data Entry Excel Google Sheets, and much more! ""I AM READY WITH OFFER BUGET"" I have experience of more than 4 years of in the freelancing field. With my skills and expertise, I can guarantee 100% success rate in your project. I have a deep understanding of the requirements of this project and I'm confident that I can provide you with the best results. Additionally, I provide regular updates during the project so that you don't have to worry about anything. Please feel free to contact me if you have any questions or would like to discuss this opportunity further.I am confident in the perfect delivery of this project in your Budget .I’ve carefully checked your requirements and really interested in this job I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. So, please get in touch with me and I will show you a sample"
$10 AUD in 2 days
5.0 (3 reviews)
1.6
1.6
User Avatar
My name is Rahmat, and I believe I am the proficient and experienced Google Sheets / Apps Script you're looking for! With over 5 years of professional experience in Excel VBA and data management, I have honed my skills to a fine art. Your project, while needing a bit of scripting, aligns perfectly with my expertise. Please find me on chat and send a detail, thanks.
$10 AUD in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
As an experienced and talented web and mobile application developer, I have a deep understanding of data manipulation, especially in spreadsheets like Google Sheets and Microsoft Excel. I have successfully executed projects that required intricate filtering and matching functionalities, just like what you need here. My particular proficiency in Visual Basic, which is highly compatible with Google Scripts, will ensure that this task will be completed swiftly and accurately. In addition, I have a proven track record of delivering high-quality outputs within stipulated timelines. Efficiency, precision, and ensuring the perfect end-product are some values that guide my work ethic. As stated in your project description, your time is valuable - with me on board, you can be rest assured that your project will be handled with utmost care and professionalism to deliver results that match or exceed your expectations. Finally, I would like to note that my commitment to professional growth has been acknowledged through industry awards such as the 2018 Webby for Best Navigation and Structure. I believe this not only demonstrates the quality of my work but also my relentless drive to enhance user experiences. With all these skills and accomplishments behind me, I am fully confident in my ability to successfully transform your complex dataset into a tool that simplifies your assigning process effectively. Looking forward to discussing this project with you further!
$100 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello There. I am writing to express my interest in the Google Sheets/Excel Expert position you have available. With extensive experience in data management and automation, I am confident in my ability to effectively fulfill the requirements of this project. Here's a brief outline of how I propose to tackle the project: 1. Set up a Google Sheet with two tabs: one for master customer data and another for payment data. 2. Develop a script to filter and match customer names from the payment data tab with the corresponding sales representative from the master customer data tab. 3. Create a new column in the payment data tab to insert the sales representative's name based on the matching process. 4. Implement automation to ensure seamless execution of the filtering and matching process on a weekly basis. I am proficient in scripting languages such as Google Apps Script and Excel VBA, which will be essential for automating the required tasks. Furthermore, my experience in data analysis and manipulation equips me to efficiently handle the complexities of this project. I am eager to discuss this opportunity further and provide you with a demonstration of my capabilities. Please feel free to reach out to schedule a time for a discussion or to receive the loom video demonstration. Thank you for considering my proposal. I look forward to the possibility of collaborating with you on this project. Sincerely, Adnan Iqbal
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
As an experienced freelancer specialized in Data Entry and Processing, your Google Sheets project is a perfect match for my expertise. Over the years, I have honed my skills in transforming large amounts of information into concise, actionable formats. Your task of filtering and matching customer names to reps is one I'm well-equipped for. My proficiency with both Excel and Google Sheets will ensure that your data is neatly organized and efficiently processed. Moreover, I’m adept in using scripts to automate tasks, which is a valuable advantage given the frequency of the task at hand. Not only can I fulfill your immediate need, but I can also offer long-term solutions to streamline your workflow. My commitment to excellence and meticulous attention to detail allows me to deliver error-free results ahead of schedule. Finally, with my track record of adapting quickly to new projects, tools, and technology, you can trust me to astutely comprehend your provided video explanation. Let's transform your data management process and turn your ideas into tangible success! Reach out today so we can get started.
$10 AUD in 2 days
5.0 (1 review)
0.0
0.0
User Avatar
Hi! I am Martin Bustos Nieto. I've a Bachelor's Degree in Business Administration, National University of San Juan (UNSJ). I believe I can do this job quickly.
$20 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm new to this platform, but I assure you of delivering efficient results. I am ready to start working immediately after bid acceptance. If you have any query please let me know. Best Regards, Muhammad Annas
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
As a seasoned Software Engineer with an extensive background in data management, I am confident in my ability to meet and exceed your requirements for this project. My strong expertise in Google Sheets and Excel, combined with my detailed-oriented approach, make me an excellent fit for the task at hand. Whether it entails filtering data, matching names, or creating new columns based on specific criteria, I am well-versed in utilizing scripts and formulas for automating such processes. My proficiency in HTML, CSS, JavaScript, alongside my vast experience in web development and data entry allows me to understand complex relationships present in your data and provide effective solutions.I will bring to bear my project management skills as well should they be needed from tracking your weekly updating sheets. In conclusion, by choosing me for this project you'll be choosing someone who brings a wealth of experience, technical expertise and unwavering diligence to every task I undertake. As any good Software Engineer knows that "A stitch in time saves nine" which my application of streamlined processes would definitely save you time and undue labour. Let's delve deeper into the project - let me bring the solution you need to the table now!
$20 AUD in 7 days
5.0 (1 review)
0.0
0.0

About the client

Flag of AUSTRALIA
Richmond, Australia
5.0
129
Payment method verified
Member since Feb 12, 2012

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.