I have an inventory of items in a sheet named Working Population. I would like to write some code that allows someone to select the names of the Associates that are in the office that day, then have Excel auto-enter those names into column E (the same process would happen in column J, but with a different set of names). Here's how the workbook is structured:
Column E = Initial Processor
Column J = Secondary Processor
Column O = Inventory ID
I have a named range on a separate sheet, that houses the names of people eligible to be entered in columns E and O, respectively.
My thought process is, launch a form where someone selects the names of the people that are in the office, from a listbox. Then, Excel starts populating said names in the correct column. The distribution should be as even as possible. So, if there are 3 names (Dan, Sue, Tommy) and 30 records where column O <> "" AND column E = "", then Dan would get 10, Sue would get 10 and Tommy would get 10. If there are 31 records, Dan would get 11, Sue would get 10 and Tommy would get 10.
I've done a lot of googling on the topic yesterday and today, but nothing seems to have the element of selecting options from a list, establishing the pattern, then repeating the pattern.
Thoughts on the best approach? I'm happy to research and work it out, but I'm not sure where the jumping off point is.
Column E = Initial Processor
Column J = Secondary Processor
Column O = Inventory ID
I have a named range on a separate sheet, that houses the names of people eligible to be entered in columns E and O, respectively.
My thought process is, launch a form where someone selects the names of the people that are in the office, from a listbox. Then, Excel starts populating said names in the correct column. The distribution should be as even as possible. So, if there are 3 names (Dan, Sue, Tommy) and 30 records where column O <> "" AND column E = "", then Dan would get 10, Sue would get 10 and Tommy would get 10. If there are 31 records, Dan would get 11, Sue would get 10 and Tommy would get 10.
I've done a lot of googling on the topic yesterday and today, but nothing seems to have the element of selecting options from a list, establishing the pattern, then repeating the pattern.
Thoughts on the best approach? I'm happy to research and work it out, but I'm not sure where the jumping off point is.
