Add a column next to current cell

  • I have a duplicate data checker which also checks the discrepancy between columns based on the ID number. The problem is, this concatenates the values but what I would like to achieve is: if they have the same ID number, everytime a unique value in the same column is found, it should insert a new column on the right side where the unique value should be outputted.

    For example:

    | Employee ID | Status |
    E100 Deactivated E100 Activated

    should be:

    | Employee ID | Status | Status (2) |
    E100 Deactivated Activated

    Instead of:

    | Employee ID | Status |
    E100 Deactivated,Activated

    I have inserted below what I have done so far. I would really appreciate help in this as I am new to programming and VBA.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!