Hello, I'm looking to delete an entire row from data, if a date in a cell before the underscore is the same as the date after it. Rest of the characters can be set to anything with regex. All cells in column 'D' follow this format:
XX.XXXXXXXXddmmyyyy_ddmmyy_X123456
I've tried using InStr as well as some sort of regex to solve this but couldn't really get it to work the way I wanted to, perhaps due to the date formatting or the fact that the same cell is being compared with itself, and so I'll greatly appreciate your help with this.
Thanks!
Bookmarks