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.
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.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
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
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 best for you to work with google sheets, since is online you can access it from anywhere.
I can automate all those parts and even to send
the emails automatically in bulk.
You will just need to import the data and press a button and all the cleaning and replications will be performed and and I could add another menu to use when you want to send the emails.
Hope to hear from you soon.
Best wishes,
Lucian