VBA to remove duplicates starting from the top

[GreenTee]

Hello VBA Community,

I'm trying to figure out the best way to remove duplicates. I have a sheet that gets rows added from the bottom and column A will have duplicate values. What I'm trying to do is remove the older duplicates that are in higher rows.

Unfortunately this code removes duplicates from the bottom. Any idea how I can manipulate it to remove rows that are above the duplicated value? Any help will be greatly appreciated.

ActiveSheet.Range("Table1[#All]").RemoveDuplicates Columns:=1, Header:=xlYes

Thanks.