Google Sheets Automation / Macros / Scripting

Closed Posted 5 years ago Paid on delivery
Closed

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.

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #18644656

About the project

16 proposals Remote project Active 5 years ago

16 freelancers are bidding on average $35/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
(375 Reviews)
8.1
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
(160 Reviews)
7.5
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
(102 Reviews)
6.3
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
(76 Reviews)
6.1
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
(93 Reviews)
6.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
(1 Review)
4.6
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
(8 Reviews)
3.9
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
(2 Reviews)
1.6
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