Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
How do I do numbering of rows in Excel when there are blank rows? | Excel Discussion (Misc queries) | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |