VBA Excel deleting duplicates

[RahafSaud]

Hi,

I have created a Macro that pastes monthly data to different workbook, but i want to add a line that delete any duplicate that might arise from running the macro multiple times.

I would really appreciate your help

[Aussiebear]

Since Excel 365 has this function already, have you tried to record a macro with this function to see how it might be applied?

[p45cal]

Cross posted