We get upwards of 25k lines of data that have to be distributed amongst 5 workers twice a day. That data is then processed further outside of Excel. I am looking for a way to segment the data equally after pasting the raw data into an aggregate data sheet. Right now, it is just a cut$paste, which certainly works fine enough, but it would be great to streamline the process by figuring the distribution and automatically segmenting it out.

I would like to create a dynamic breakout of data that comes in daily at varying sizes. The breakouts have to be a distribution of the rows of data across 5 report sheets. For example, if there are 10 records (on the aggregate data sheet), the ensuing 5 sheets would each get 2 data rows. On another day, there may be 15 rows of data, so each report would get 3 rows of data.

How would I get the reporting sheets to evaluate the total number of lines, divide it out those lines by the number of distributed sheets and place the return the appropriate lines to each of the 5 sheets?

Thanks.

J-