Hello all
Long time newbie still trying to tackle this one. I'm seeking help with code to loop and fill the attached worksheet Slot column with the techs first choice that is not a duplicate above from more senior tech. The techs are listed down column A with the most senior tech able to get first choice. If the next tech down the list bid the same choice as the first tech the the code would select the next choice.
Thanks for the opportunity
RL
Last edited by RlHamor; 10-23-2013 at 03:01 PM.
Welcome to the Forum!
Thank you for the title change, carry on.
Last edited by 6StringJazzer; 10-23-2013 at 04:59 PM. Reason: OP complied with request
I have your solution when the title has been changed.
My solution copies the data into a VBA array.
And populates a Unique collection with each users valid choices.
The collection is then converted to an array
Finally the array is written back to Excel.
As there is only one read and one write action the process is fast.
Unfortunately I cannot post the code or the sample until you comply with Jeff's request.
Thanks mehmetcik,
Here It is:
Please Login or Register to view this content.
Solvedthis works like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks