Sorry, I don't really know if I understand what the code you offered is doing... It doesn't seem to specify anywhere that this should be done in Column E and that the cell content in column E only is to be cleared if it doesn't have 'Volunteer & Internship'. Could you please explain? Thanks.