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
Bookmarks