Removing Duplicates in a Table

[brentjohn]

Greetings,
i am using the following code to remove duplicates from Table2. However, when I try to use another macro to place the values of Table1 into Table2, all the data is not "transferring" because Table2 has removed rows when the duplicates were removed. I am needing to make sure Table2 has the same number of rows as Table1.

Please Login or Register  to view this content.

[Akuini]

Try this:
This will keep the number of rows the same as before removing the duplicates.

Please Login or Register  to view this content.

[brentjohn]

Akuini,
Works perfect! Thank you much!

[Akuini]

You're welcome, glad to help, & thanks for the feedback.