Splitting data from sheets into seperate workbooks based on formul
 

Hi all,

I have a problem splitting up data into seperate workbooks.

I have a workbook with 3 worksheets.
One is data of one worklist, second is data of another worklist. The field
names are totally identical in each.
The third simply counts the amount of data in one column of each of the
sheets, the user then inputs how many people will use the data giving us
amount of data per user.
However i now wish to split the data into the amount of new workbooks as
there are users and split the data accordingly across these new workbooks.
It would also be splitting the two worklists seperately as one would be done
in the AM and one in the PM.

I have searched the net and no-one seems to have had this problem, maybe im
going at this the totally wrong way,
Any help is much appreciated.

Thanks in advance

Mikey

Splitting data from sheets into seperate workbooks based on formul
 

Hi bUncE

You can try this
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"bUncE" wrote in message ...
Hi all,

I have a problem splitting up data into seperate workbooks.

I have a workbook with 3 worksheets.
One is data of one worklist, second is data of another worklist. The field
names are totally identical in each.
The third simply counts the amount of data in one column of each of the
sheets, the user then inputs how many people will use the data giving us
amount of data per user.
However i now wish to split the data into the amount of new workbooks as
there are users and split the data accordingly across these new workbooks.
It would also be splitting the two worklists seperately as one would be done
in the AM and one in the PM.

I have searched the net and no-one seems to have had this problem, maybe im
going at this the totally wrong way,
Any help is much appreciated.

Thanks in advance

Mikey