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.