I have an excel spreadsheet of raw data in Sheet1. The raw data should remain intact.
There are a variable number of keywords, E.g. meeting, conference, briefing, etc.
Based on the data in "Trip Description" (Column M), remove records if they contain these keywords.
Make it so that this is a loop based on number of keywords.
Based on the "Pick Up Time Local" in Column G, remove records if it is on Saturday or Sunday.
Based on the "Pick Up Time Local" in Column G, remove records if they are before 7am or after 9pm.
There is a variable number of Known_Addresses.
If Pick Up Address (Column I) and Drop Off Address (Column J) both matches the set of Known_Addresses, remove the records.
For the remaining records, display them in another worksheet. The user can delete some of these records, and may leave black rows.
Create a button on the sheet for the user to send a email to all the people in the records.
The email shall be sent to "Employee Email Address" (Column F), with subject "test", and the body that includes Dear <Employee Name (Column B)>,
Please provide readable codes as I will be making changes to them
Hi, bro!
I have read your requirement and I noticed that I am appropriate to this project.
I have rich experience with email handling using Excel VBA.
Everyone call me a "Prince of Excel".
I promise I will finish this project with high quality on time.
I hope you to contact me so that we have a full discuss with the project.
Best regard!
$30 SGD in 1 day
5.0 (3 reviews)
2.3
2.3
4 freelancers are bidding on average $61 SGD for this job
Hi, there.
I have read your project description very carefully so I had confidence that I can do it.
But some problem you need for the project will discuss with me before starting work, I think.
I have experience over 5 years with the skills you required.
So this project you post can be completed excellently for me, I think.
....
Best regards.