hi pyol17, your file title made me laugh a little. not really a good title to attract helpers by labelling our forum redundant eh? haha. to make it automatic, you are probably gonna involve VBA. so i can't help you on that part. but it seems like you need to remove duplicates & Excel 2007 has that function to do that. it's manual each time though. click on any 1 cell within the data. go to Data -> Remove Duplicates. Ensure that "My data has headers" is checked. Deselect Description & Finish Date. Click OK.