View Single Post
 
Old 12-10-2014, 08:44 AM
zipp77ez### zipp77ez### is offline Windows XP Office 2007
Novice
 
Join Date: Dec 2014
Posts: 3
zipp77ez### is on a distinguished road
Default Dividing an Excel data report into even # of rows

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.
Reply With Quote