MuppetReaper
New Member
- Joined
- Jun 14, 2013
- Messages
- 30
I'm running a process that imports data into a excel table and this can be done multiple times, so I want a way to remove the older instances and only keep the newest, which would be furthest down the table.
When I've tried using the remove dupes function it always removes the bottom values, is there a way in VBA to force it to remove the older entries?
I'm basing the dupes in values in columns A and C
thanks
When I've tried using the remove dupes function it always removes the bottom values, is there a way in VBA to force it to remove the older entries?
I'm basing the dupes in values in columns A and C
thanks