I have a sheet where I import data. I have a macro setup to import all data and then filter any duplicates. I need to no longer simply delete duplicates, but delete duplicates based on date. When I import the data I need that day's date to auto appear in column C. I then need to delete any duplicates, but I need the duplicate with the oldest date to be deleted. I import data on a daily basis, so I need to automate the entire process. How do I so this?