I have created a Macro that pastes monthly data to different sheet, but I want to add a line to delete duplicates that might arise from running the Macro multiple times.
RahafS
Based Your given ... details
please, do 'Google' with excel vba delete duplicate rows
Without Your sample Excel-file with Your Macro - it's a huge challenge to offer something safe.