The comparison needs to be done on unique id between sheet 1 and sheet 2. Both the sheet have id as a column. Need to compare this column. And delete the row in sheet 2 if there is no row for a particular id in sheet 1.

Thanks!