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-


--
josephrowan
------------------------------------------------------------------------
josephrowan's Profile: http://www.excelforum.com/member.php...o&userid=14407
View this thread: http://www.excelforum.com/showthread...hreadid=509675