Check duplicates and then delete rows

[misop]

Hello,

I need some help in my project...

I have button "Aktualizuj" which allow to select excel file and paste data into first empty line. Now I want to have another button, which will do:

1. check if in row 1 are duplicates, If so, then.. step 2
2. delete line with lower number in row 2, but if it have some records in rows 3,4,5, at first copy them into the same rows in line with higher number in row 2

Is that possible?

Thanks

[misop]

can someone help me?