Consulting

Results 1 to 3 of 3

Thread: VBA Excel deleting duplicates

  1. #1

    Question VBA Excel deleting duplicates

    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

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,055
    Location
    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

  3. #3
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,873
    Cross posted

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •