+ Reply to Thread
Results 1 to 1 of 1

Macro creating duplicates (VBA code not working as it should)

  1. #1
    Registered User
    Join Date
    04-22-2012
    Location
    Derby,England
    MS-Off Ver
    Excel 2016
    Posts
    28

    Macro creating duplicates (VBA code not working as it should)

    Hi All,

    Please see attached document. It is my planning timesheet. I run a macro "AssignJob()". What happens is it looks in a Job Knowledge tab and populates the blank (red) spaces. The macro works however it is creating duplicate numbers. This should not happen. In basic terms, the function looks for numbers that are missing and if the person knows that number the cell gets populated.
    I have created several tabs to practice on and to see if you can see the "bug". They are dated in the format ##.##.## I copy and paste the master sheet into a new tab with the date format (##.##.##) 06.10.13 (as an example) press the Assign Job() macro. At this point any variables that can auto assign numbers populates the empty cells. Their should be no duplicates. This is where it is going wrong.
    Please can a VBA expert have a look and see if the bug can be found.
    Thank you
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro/VBA to Search, Copy, Paste - without creating duplicates
    By rdesio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2013, 02:39 PM
  2. Creating sinle random letter - code not working
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-27-2012, 09:38 AM
  3. Creating a macro that duplicates content depending on a number in column A
    By webuxer in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-22-2011, 02:13 PM
  4. [SOLVED] creating macro working across multiple sheets
    By Nicole Seibert in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2006, 02:00 PM
  5. Creating Macro or Code Help?
    By Jeni Q in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2005, 11:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1