#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 168
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy rows of data (eliminating blank rows) from fixed layout Sweepea Excel Discussion (Misc queries) 1 March 13th 07 11:05 PM
How do I view the maximum rows in Excel 2007 (Million Rows)? shanth Excel Discussion (Misc queries) 2 January 15th 07 05:45 PM
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th Excellent1975 Excel Discussion (Misc queries) 0 June 21st 06 08:01 PM
How do I do numbering of rows in Excel when there are blank rows? V Excel Discussion (Misc queries) 1 April 3rd 06 11:24 AM
Can Excel "slide up" rows with content thru empty rows to condense portly44 Excel Worksheet Functions 2 April 1st 05 12:47 AM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"