I have an Excel (2007 or 2010 spreadsheet that has about 870 names. I need to divide the sheet somehow (by color, skipping line or separating data) into 32 parts/sections. This will be used to give the report to 32 people who will each have to contact approximately 27 names on the report. I'd like something that stands out within the spreadsheet so each person can go to the report and find their part/section or that I can send to each without manually cutting/pasting. I started manually doing this and counting 27 but seems archaic. Is there a way, simply to do this? Thank you.

Hi
could you please post a sample sheet? Perhaps some conditional formatting might help

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

7/1/2012EricAballi3/13/2014JeremyAber7/1/2009AllanAbrams11/17/2011JoanAbrams7/1/2014JasonAckerman7/1/2014JoshuaAckerman7/1/2011MaeAdler7/1/2013MarkAdler7/1/2013RobertAdlerAbove is part of the sheet. It has 867 rows of information. I wanted to divide the sheet into even groups of 27 and show a separation at each group of 27. Then I would be asking each of 32 people to contact 27 of the names on the list. I.E. Board member Scott would call 1-27, Jeff would contact 28- 55, etc. until each of the 32 members would have their lists. Make sense? Thanks.

Please post a sample sheet, thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Have a long list/spreadsheet and want to divide into equal parts (i.e. 27 for each of 32 people to contact names). I can do the math and separate but seems crazy. Attached in sample of just names (deleted personal information). Ideally, would like each group of 27 in different colors or separated by lines and then a separate note would show Section 1: 1-27, Section 2, 28-55, Thanks.

There is nothing attached to your post.

Update: I see that you have posted the same question before. Threads merged. Please don't post the same question multiple times.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]