How to automate this process in an excel sheet?

Hey guys, i’m doing cold emailing and i have a question. When people unsubscribe from my list, how do i remove them automatically from my excel sheet? Manual work take stoo much time. Doing ctrl+f and deleting with your hand manually is too long process if there are hundreds of people each day. So my question is, how could i automatically remove people who unsubscribe? Maybe there is a program or a bot to do this? Let me know!

I once used the Recorder function to change a cell value. Not sure if you could use it for your problem. It essentially builds a small program within excel.Worth a shot. Here is the link to how to use it:
https://support.microsoft.com/en-us/office/automate-tasks-with-the-macro-recorder-974ef220-f716-4e01-b015-3ea70e64937b#OfficeVersion=Windows

1 Like