Hi,

How can I distribute 1 numbers for each cell when the maximum Last row is met and need to go back to 1?

I have 7 numbers, need it to distribute in 5 persons.

People 1 = 1
People 2 = 1
People 3 = 1
People 4 = 1
People 5 = 1

Now need to go back to People 1 to add 1 then People 2 to add 1 also.

People 1 = 2
People 2 = 2
People 3 = 1
People 4 = 1
People 5 = 1

How can I do this in a VBA macro distributing numbers,

Output of the spreadsheet will be this:

A B
1 People 1 2
2 People 2 2
3 People 3 1
4 People 4 1
5 People 5 1