Splitting data from sheets into seperate workbooks based on formul

G

Guest

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

Copying Worksheets From Different Workbooks using Marco 4
Adding data from different workbooks 3
Copy/ move selected data from workbooks to seperate worksheets or workbooks 1
Exporting data 3
Excel 2007 - Linking workbooks 1
Create different workbooks from workbooks 3
How to separate Excel Workbooks into new files 0
Combine date from multiple Workbooks into one worksheet 2

Top