No, the file just needs to be distributed across the 9 users. It could be as
first row to the first user, second row to second user, etc... When the
tenth row cam around, it would be assigned to the first user. Other than
just trying to be even, there are really no criteria that will be used for
the distribution of rows.

"Bernie Deitrick" wrote:

JD,

Do you have a criteria that you will base the row distrubution upon?

HTH,
Bernie
MS Excel MVP


"JD" wrote in message
...
I need to distribute the rows from a master workbook to other workbooks. I
need to do this one row (or small group of rows) at a time. To make the
distribution even, I cannot take the total number of rows and diveid it by
the number of sheets I need (9). IS ther a way to do this?