Is there a way that a Macro could be written to:
a) Look at the first name and surname in each row, compare it to the Known As and Surname in the MIS sheet and if it cannot find it remove the whole row from the first sheet and put it in the next blank row in sheet called Leavers?
b) Repeat for all sheets that begin with a P or Ante
Bookmarks