How to add data to shared excel sheet where it shows only the recent data

Hi  I'm having a situation where require to copy paste the data in a shared excel file 3 times a week and the other person updates "comment" column and the sheet needs to be checked for duplicates. ...