Removing duplicates based on date criteria?

[Z74]

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?

[ragulduy]

Can you post the code you are using at the moment? Also a workbook with some sample data?

One method would be to use the now function to get the date:

Please Login or Register  to view this content.

Then when searching for duplicates you can use something like:

Please Login or Register  to view this content.