Encerrado

Google Sheets Macros Expert

I'm looking to work with someone who can build automation into a spreadsheet, so that I can take data and reformat it automatically, using automation, macros, etc.

The data is a list of property owners and the addresses of the properties they own.

i need to

1. migrate from raw data into clean data template. If you reference the clean-transition tab, the first two columns have the headers from the RAW tab in red and CLEAN tab in green. So you will first need to migrate data from RAW to CLEAN so that it matches Clean-Transition tab. Once you the CLEAN-Transition and CLEAN tabs look identical, please process the rules below.

2. migrate foreign addresses from main list into FOREIGN ADDRESS tab

3. migrate all entries without an address from main list to NO ADDRESS tab

4. migrate all entries without a first/last name to BUSINESSES tab

5. migrate all entries with only a first or last initial in the name to INITIALS ONLY tab

6. duplicate main tab and rename copy as LS - TO BE IMPORTED - PEOPLE

7. take the other main tab and remove duplicate entries and rename to TO BE MAILED - PEOPLE

8. Go to BUSINESSES tab and duplicate it

9. name one BUSINESS tab as LS - TO BE IMPORTED - BUSINESS

10. rename the other BUSINESS tab as TO BE MAILED - BUSINESS and remove all duplicates

Please submit a proof of concept file back to me with the above steps done. if you can do it successfully, i will hire you. if you can't, then this is not the right job for you.

Also, to verify that you read the instructions, please type TUESDAY TROUBLE at the beginning of your response. Thanks.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Visual Basic, Visual Basic para Apps

Veja mais: google sheets consultant, google sheets automation, google sheets macro button, google sheets templates, google sheets programmer, ask a google sheets expert, google sheets help, google sheets tips, google maps api expert, salary google certified ppc expert, google map api expert, foreign address look address, google maps javascript expert, google base api expert, google maps listing expert, excel macros expert jobs, google maps distance calculator api using address, google shopping cart expert, google warrior macros, google map listing expert

Acerca do Empregador:
( 3 comentários ) Aldie, United States

ID do Projeto: #18665403

5 freelancers estão ofertando em média $9/hora para esse trabalho

schoudhary1553

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 profile. Mais

$15 USD / hora
(317 Comentários)
7.8
SBITServices

TUESDAY TROUBLE Hello , I have checked the excel, read your project description and understood your requirement.I can develop a Google sheet script as per your requirements . I have done projects on dev Mais

$5 USD / hora
(459 Comentários)
7.5
daniyal3214

I am a professional Data Analyst holding years of experience in utilizing advance level tools and functions of Excel and Google Sheets.

$8 USD / hora
(47 Comentários)
5.4
ioanaprof

TUESDAY TROUBLE Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. All your requirements are achievable. Thank you for your time ! John

$8 USD / hora
(21 Comentários)
4.1
parau

TUESDAY TROUBLE Hi there, My name is Lucian and I am an implementation engineer. I work daily with google app scripts and google sheets formulas on my job and I have done here few amazing projects. I believe is bes Mais

$8 USD / hora
(4 Comentários)
2.6