Closed

Google Sheets Automation / Macros / Scripting

This is NOT a data entry job. Please don't message me unless you know how to do advanced google sheets data manipulation.

I have a set of "raw" data. I want to clean it up and format it into a new tab in google sheets, using macros, scripts, automation.

the raw data has a list of owners and the real estate properties they own.

these are my rules

1. i only want to send one letter to each property owner

2. business and people owners will have two different letter templates used so that they need to be separated

3. duplicate owners should identified so that i only send one letter per owner, but i am putting all the data into podio, so i don't want to delete duplicates. i just don't want to mail to them.

attached is a sample spreadsheet.

when you reply, please type "ALOHA" so that i know that you read the ad. If you do not type this, i won't even look at your reply.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel macros scripting vba tutorial, php macros scripting automation, google earth scripts macros, google sheets record macro, convert excel macro to google spreadsheet, google sheets macro example, can you use macros in google docs, google sheets script functions, google sheets macro button, google sheets script examples, google sheets macros language, google news automation, excel database automation macros, excel automation macros, google chrome automation, script update cell google sheets, google sheets calendar integration, programming google sheets, excel convert google sheets, google docs excel macros

About the Employer:
( 3 reviews ) Aldie, United States

Project ID: #18644656

19 freelancers are bidding on average $36/hour for this job

schoudhary1553

"ALOHA" Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my More

$41 USD / hour
(316 Reviews)
7.8
zekovicm

Hi there,I am Google sheets expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within More

$33 USD / hour
(117 Reviews)
7.2
sonarkaushik

ALOHA Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear More

$33 USD / hour
(103 Reviews)
6.2
archanaoswal

ALOHA I have excellent command on Google Sheets. I have completed complex projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo More

$25 USD / hour
(85 Reviews)
5.9
Devrits

"ALOHA" Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. A◙ I can do Data RESEARCH from any platform for certa More

$25 USD / hour
(36 Reviews)
5.4
mtanveer2012

ALOHA I have good experience in data manipulation and making scripts. I am confident I can exceed your expectations. I can start to work in your project immediately. Please contact me, So we can discuss more over chat More

$25 USD / hour
(48 Reviews)
5.4
amrosamaeg

ALOHA Hello, Over 15 years of real experience working as a developer, Top rated freelancer on Upwork Skills, Portfolio, Tests, Education, Certifications, Work/Employement history and feedback can be found in my pro More

$41 USD / hour
(10 Reviews)
4.2
sdroberts

Aloha I would love to help with your macro query. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba More

$33 USD / hour
(7 Reviews)
3.9
ming87

"ALOHA" Dear sir, Nice to see you. While I read your description, I was excited due to feeling that I would be able to satisfy for your requirements in this job. I have rich experience and expertise to develo More

$41 USD / hour
(6 Reviews)
3.0
Ddvoryan

Hello. I read your job post carefully and I am confident in this job. I am expert in Excel/VBA and I am confident with any kind of Excel/VBA project. I think I'd be a great fit on this job and I can give you perfect More

$44 USD / hour
(2 Reviews)
2.7
jonlutz79

Hi there, I see you’re looking to develop a Google Sheet to automate a mail merge process. Whether your project involves complex formula creation, custom Apps Script development, or dashboard development, I can he More

$50 USD / hour
(1 Review)
1.6
soery4

ALOHA, I am interested to work on your project. I have experience to work on spreadsheet (excel, google sheet, openoffice), so that I believe I can do the job well. I have seen your file, but I have some questions. More

$30 USD / hour
(1 Review)
0.4
Aloshya

Google Sheet Auto Inserting Script Promised. I am expert and Google SDK and Google sheet api are also my favorite one. i am perfectly sure that i can make you satisfy with perfection.

$41 USD / hour
(0 Reviews)
0.0
ygenchik

ALOHA Dear Employer, In general, data cleansing projects involve data normalization in certain respects. They take plenty time, as there is always a need to parse, categorize, remove duplicates, and if there are sp More

$35 USD / hour
(0 Reviews)
0.0
techsysipljpr

ALOHA Hi there, Greetings! I am expert of google sheets and google scripting. I have done advance level of formulas and scripting. I have few samples to show you. Love hear you soon to discuss in details. Regards Ra More

$27 USD / hour
(0 Reviews)
0.0
ChernenkoEgor

ALOHA I can clean it up and format it into a new tab in google sheets, using macros, scripts, automation. Higher-quality and faster-delivery is promised. Your job seems to be posted only for me not for the others, b More

$50 USD / hour
(0 Reviews)
0.0
iamhealey

Hi there! Aloha! I'm an Excel and Google Sheets expert with experience in automation of document production. I specialise in using databases to produce well-formatted documents at the click of a button. I have pr More

$27 USD / hour
(0 Reviews)
0.0
IonRod

Aloha! I can do that for you. I really enjoy such tasks - to go into data. I often deal with such tasks and I'm using a set of tools: Google Spreadsheet / Scripts / Pivot table for simple manipulation and data a More

$40 USD / hour
(0 Reviews)
0.0
saurabhchem09

ALOHA Hi, I'm good at advanced data manipulation google sheets. You can offer the job to me with full confidence in me.

$41 USD / hour
(0 Reviews)
0.0