Splitting data from sheets into seperate workbooks based on formul

B

bUncE

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Data consolidation 0
Split data from 1 workbook into multiple workbooks based on criter 0
Split Data Series (Lookup, Index, Match references) 1
Copying Worksheets From Different Workbooks using Marco 4
Extracting data from database into separate sheets 0
Linking data in MS Word into Excel 5
Adding data from different workbooks 3

Top