Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    20

    Unanswered: Ignore Duplicate Data

    I have a spreadsheet listing empid and shifts/dates worked. I need to insert missing dates. The first stumbling block was duplicate dates - some emps work 2 shifts in the same day . I resolved this issue but in moving to the second person/iteration the wrong dates are inserted. I think it has to do with resetting the variables but I CAN NOT figure out how/where to do this.

    I have been working on this one last thing for DAYS and I have run out of patience with it. Any help would be appreciated more than you could possibly imagine!

    I've attached the spreadsheet with the macro to hopefully give a better picture of what I'm trying to do.
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2010
    Posts
    20

    Got it!!

    I see there is interest in this posting. Well......I have FIANLLY gotten this procedure to work SO I am sharing the wealth.

    Attached is the code.
    Attached Files Attached Files

Posting Permissions

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