Hi,
I know there are a lot of posts on duplicates here but I can't seem to find anything that fits my description. I have a column of data that generally looks like this:
ABC00001
ABC00002
ABC00003
ABC00004
ABC00005
etc, etc.
There are sometimes blank cells in between and the numbering is not necessarily in order. I have another macro that runs on a BeforeSave event to create these values. Now, there are multiple users that use my file and sometimes they will copy a row and insert it as a new row in the sheet as a quicker way of adding information to the spreadsheet, but this duplicates the numbering system I built and the values need to be unique. In order to do that, I need a macro that will look at this column and remove duplicates so that my other macro will generate a unique value in the blank cell. (My macro doesn't touch the row once there is a value). Is there a simple macro that can be created (or incorporated into my existing macro) that will remove any duplicates in column G before my other macro runs. When I say remove duplicates, I mean clear contents of the cell, not delete the cell or row. Thanks!
Bookmarks