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.
Sub removeDuplicates_FZ()
Dim ws As Worksheet
Dim tb1 As ListObject
Set ws = ActiveSheet
Set tb1 = ws.ListObjects("Table2")
tb1.Range.RemoveDuplicates Columns:=1, Header:=xlYes
End Sub