Excel macro to count the number of rows, divide them by user defined number, and copy and paste into different sheets

[jeremiah_j2k]

I have excel sheet with data in many rows.
And the no. of people working on the data keeps changing.
I want a code that will divide the no of rows equally whatever available into the number of people working on sheet that day. So that they know who is working on what row.

Severity	Owner	ticket no.	Substatus	Customer Code	New Status	Remarks	Modified By
2-Medium	BAECOE	1245789	Scheduled	132548
1-Low	NUEEBALA	1245790	Scheduled	465
1-Low	NUEEBALA	1245791	Scheduled	654849
1-Low	NUEEBALA	1245792	Scheduled	546
1-Low	CRUZS	1245793	Scheduled	313546
1-Low	DELACRUZS	1245794	Scheduled	54
1-Low	DELACRUZS	1245795	Scheduled	6546549
1-Low	DELACRUZS	1245796	Scheduled	251654
1-Low	CRUZS	1245797	Scheduled	32165
1-Low	DELOSREYESD	1245798	Scheduled	64654
1-Low	ROQUE	1245799	Scheduled	1545
1-Low	CRUZS	1245800	Scheduled	6546654
1-Low	CRUZS	1245801	Scheduled	654654
2-Medium	BAECOE	1245789	Scheduled	32168498
1-Low	NUEEBALA	1245790	Scheduled	321684
1-Low	NUEEBALA	1245791	Scheduled	32164
1-Low	NUEEBALA	1245792	Scheduled	354984
1-Low	CRUZS	1245793	Scheduled	643535
1-Low	DELACRUZS	1245794	Scheduled	6984531
1-Low	DELACRUZS	1245795	Scheduled	6541
1-Low	DELACRUZS	1245796	Scheduled	6964
1-Low	CRUZS	1245797	Scheduled	41635
1-Low	DELOSREYESD	1245798	Scheduled	7968541
2-Medium	BAECOE	1245789	Scheduled	32168
1-Low	NUEEBALA	1245790	Scheduled	68413
1-Low	NUEEBALA	1245791	Scheduled	8465498
1-Low	NUEEBALA	1245792	Scheduled	787989
1-Low	CRUZS	1245793	Scheduled	313546
1-Low	DELACRUZS	1245794	Scheduled	876
1-Low	DELACRUZS	1245795	Scheduled	5498451
1-Low	DELACRUZS	1245796	Scheduled	841
1-Low	CRUZS	1245797	Scheduled	68541
1-Low	DELOSREYESD	1245798	Scheduled	64654

<tbody>
</tbody>

 

[jeremiah_j2k]

Up.. Please help