Removing Duplicates in a Table

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.

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

Please Login or Register  to view this content.

Akuini,
Works perfect! Thank you much!

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