good morning, I am looking for help on a VBA macro that will allow me to keep certain rows that contain a certain word in the column and delete the other rows. In column F (location name) we want to keep anything that has "CON" in it and in column C (company name) anything that has ABC2 in it. If it does not meet one of those two criteria then can be deleted.
BEFORE
After
Any help in this is GREATLY appreciated. Thank you
BEFORE
Employee Name | Employee ID | Company Name | Hire Date | Job Profile | Location Name | Worker's Manager |
Test 1 | x | ABC2 | 3/13/2023 | Agent | Remote | John Smith |
Test 2 | x | Company 1 | 3/13/2023 | Representative | Remote | John Smith |
Test 3 | x | Company 1 | 3/13/2023 | Representative | CON FL | John Smith |
Test 4 | x | Company 1 | 3/13/2023 | Representative | Remote | John Smith |
After
Employee Name | Employee ID | Company Name | Hire Date | Job Profile | Location Name | Worker's Manager |
Test 1 | x | ABC2 | 3/13/2023 | Agent | Remote | John Smith |
Test 3 | x | Company 1 | 3/13/2023 | Representative | CON FL | John Smith |
|
Any help in this is GREATLY appreciated. Thank you