I need help to create an Excel VBA script that produces an amount of possible combinations with certain criteria regarding salaries and points.
I will provide a list in excel that will include 3 columns: name, salary, and points. This script should generate from 1 to 150 outcomes while picking 6 names but staying between $37,000 and $50,000 total salary. The outcomes need to sort by highest possible points first.
If this project is successful, there will be other similar projects for you to bid on.
The total salary for each 6 name combination cannot exceed $50,000 and go no lower than $37,000.
A name cannot be used more than once in the same output.
I would like the ability to select how many outputs to generate, from 1 to 150.
I will provide the list to the winning bidder. I want this to be something that I can easily run on my own as I add new names and salaries. This needs to be finished by Thursday, Feb 23 or Friday Feb 24 2017 at the latest.
37 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi there, I'm interested in the job and can help get it done within 1 day. Feel free to contact me an discuss more details. Look forward to hearing from you soon. Best Regards, VL
Hi, I am an Excel VBA expert and can handle the project requirements. Also, I have been involved in some similar projects earlier. Shall try to make the solution user friendly. Let me know. Regards, Arul
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
Hello, I can write a macrc code by vba for your excel as you want. I can do it about in 2 hours if it intested you can send me the file and you will give me the job when I send you the finished work.