I need some help creating a macro. Or a way to do a process quicker
I need to
1. Find Duplicate reciepts (need to check against 3 different variables to make sure they are actual dups in my worksheet)
2. I need to delete one of the duplicates
Right now I create a new column use concatenate from 3 different data cells. Paste this all the way down. Then using conditional formatting for duplicates and then going one by one and deleting one of the duplicates.
It was okay for awhile, but now I have too much data - Any help is greatly appreciated
Mike