Excel Rows
 

I have a spreadsheet of about 5950 rows and have 34 people that need to work
the data that is contained in the rows. Is there a quick way I can break the
rows down into 34 equal groups so I an assign a block of rows to each person?

Excel Rows
 

Without taking time to write a macro for you (sorry, I have to leave), you
could just copy rows 1:176 (assuming headers are in row 1), open a new
workbook and hit enter to paste the data, save and distribute that file to
worker #1, go back to your original list, highlight rows 2:176 and
right-click | delete, then repeat the process.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"fluffy" wrote:

I have a spreadsheet of about 5950 rows and have 34 people that need to work
the data that is contained in the rows. Is there a quick way I can break the
rows down into 34 equal groups so I an assign a block of rows to each person?