Hi

Can some one help me with the code to allocate inventory equally

Inventory Table:

Group Number - Work - Allocated To(Person Name)

Reference Table:

Group Number1 - Person1-Person2 - Person3 - Person4
Group Number2 - Person2-Person4 - Person5 - Person6
Group Number3 - Person1-Person3 - Person5 - Person6


Code required:

Inventory table has fresh inventory where few person names already exists
Reference table has list of group numbers and person authorized to process that group
Allocation should be done in Inventory table with equally to all (Existing+Fresh) Number should be equal.

Hope I am able to explain the logic.

Kindly help... please guide how to do & functions that need to be used if entire code can't be provided.

Thanks in advance