Hello,

I am trying to solve a problem that i dont know how to even start or approach. I have a excel sheet with approximately 15,000 records, this table is automatically updated; however to delete the records are very manual and I am trying to automate that process. Currently to delete a record, an email is sent with the information to be deleted and someone has to manual go in the table and remove it. This can be very time consuming because records are randomly sent to be deleted throughout the day.

Is there any way to have excel read an email subject line and automatically search the excel table and remove the corresponding record?