For some reason, for the life of me, I cannot find any relevant information online to what Im trying to accomplish here.
Essentially, all im trying to do is create a macro that takes the value in E2 (which will be a dropdown list), searches it in the table pictured left, finds that name & deletes it ALONG WITH the cell next to it and shifts rows up.
To create a background to this situation, employees editing this table continuously remove names and simply leave the cell blank, therefore the list is spaced out and it drives me nuts. Im simply going to lock them from editing cells on the table and create a delete name button so they have no choice but to delete & shift cells up.
Help is VERY MUCH appreciated. Thank you to this community!!
