I have written a random number generator that will generate between one and ten numbers depending on the users input (in a combobox). this part is working fine. I now need to compare those numbers to a list of employees. the employee numbers are not sequential. So far I can take the generated random numbers and compare them to the array of employee numbers(A column on sheet 2) , and if the numbers match plug the matching number into a cell (C column on sheet 1). I am stuck at trying to loop through the code until I have a match for the amount that the user has chosen.
I would like someone to explain in detail how to do this ( for example, if the user chooses to get 5 employee numbers at random, the code loops through employee number until it matches 5 random numbers) I would also like some advice on how to match the random to the employee numbers without using brute force like I have done. the file is attached.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.