I would like to auto generate group numbers. I allotted their seniority by their date of join and date of birth by a macro.
Now I want number their group and their membership.
Here is the concept:
I want update two columns GROUP and MEMBERSHIP as the following criteria.
> A group has one admin, one moderator and 5 members
-> Based on the seniority First n members are admin for the each group next n members are moderator for the each group and the following n members are members.
(the value of n can get from form combo box (n- No of Group need)
Example:
If I want 5 groups then GROUP column should be updated as
GROUP MEMBERSHIP
Group1 Admin1
Group2 Admin2
Group3 Admin3
Group4 Admin4
Group5 Admin5
Group1 Moderator1
Group2 Moderator2
Group3 Moderator3
Group4 Moderator4
Group5 Moderator5
Group1 Member11
Group2 Member21
Group3 Member31
Group4 Member41
Group5..... Member51 Like wise....
for members only the increment number is followed by the group number.
How can I do with VBA..?
I attached my file here.GroupCreate.zip