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
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
Since Excel 365 has this function already, have you tried to record a macro with this function to see how it might be applied?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Cross posted