copy paste usedrange data and delete duplicate rows

Hi friends,

Once again i need your help, below are the things which i am trying for my code to perform.

• Copy data from range B5:F13 (range will not be fixed)
• Go to sheet “Archive” paste copied range as value from cell A3
• Delete duplicate rows from sheet “Archive” (Like in the sample file last two rows are duplicate so they should get deleted) may be concatenation formula be used for it
• After a month again some new data can be manually added in sheet “Master” below the existing data. So next time when the same VBA code is executed then the whole copied data from “Master” sheet should be copied and pasted in sheet “Archive” below the data which is present earlier. After that again the VBA code should search for the duplicate rows from the entire data and delete it

Link for the sample file
Sample data.xlsm

Try

Please Login or Register  to view this content.

Thanks a lot Mumps1. it is working exactly how i wanted it to be, let me try tomorrow in the actual file. Hope it will work there also.

Thank you for your help

My pleasure.