Assigning rows evenly and in an order between members who will be working on them

[salmanhuss]

Hello,

I have a problem Im trying to figure out in Google spreadsheets(maybe similar to Excel). I have a list of several rows everyday and they need to be distributes/assigned between four people evenly to work on them. I want it to be distributed in an order with some formula so the time in selecting their name and dragging down each day to the exact number of assignments doesn't happen everyday. Im looking to save time with this solution. I have attached a screenshot as an example of how that should be distributed evenly between members to work on these lists.

Could someone please suggest a solution to this? Really appreciate your expertise.

[JeteMc]

Hello salmanhuss and Welcome to Excel Forum.
You will usually get faster answers if you attach an Excel spreadsheet, instructions are in the banner at the top of the page.
As you are new I have produced one for you this time.
Proposal is to list the names in a separate column, i.e. column E
The formula for column B could be: =INDEX(E$1:E$4,MOD(ROWS(A$1:A1)-1,COUNTA(E$1:E$4))+1)
Let us know if you have any questions.