Consulting

Results 1 to 2 of 2

Thread: Avoid duplication in copying

  1. #1
    VBAX Newbie
    Joined
    May 2016
    Posts
    1
    Location

    Avoid duplication in copying

    Hi I am copying data from a worksheet in txt format (File name : Nov 2007) using macros to another excel file . The data is consisting of 200 records staring with month name "Nov 2007" . I want the macro to check and warn me if someone again opens the file Nov 2007 txt file so that the november records are again not duplicated in the excel file . what is the code which i can use to avoid this duplication

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Something like
    if not Range("A:A").Find("Nov 2007") is nothing then Exit sub
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

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