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