Copy Row Automation causing duplicates
I am using an automation that copies rows which contain the word "submittal" into a sheet where we are tracking submittal dates for all our projects. I cannot use a report because we need to be able to publish to a calendar. Therefore, the end result must be a sheet. As most of you probably know, these dates can change quite often. Every time the date is updated in the source sheet, it copies over as a new row instead of just updating the information from the original copy thereby causing numerous entries for the same item. This is causing multiple dates for the same item and confusion all around. Is there a way to do this without manually deleting all the duplicates?