Split data from 1 workbook into multiple workbooks based on criter

B

bUncE

Hope the title isn't too confusing/misleading,
Im trying to split the data in one workbook into multiple workbooks which
will then be saved individually (with same name each time to same location).
I also have a cell containing the amount of data eg 1000, another
containing the amount of people who are in to work the data eg 10 and another
that will have amount of data per rep (in this case 100)
So is there any way for excel to split the data into chunks of 100 in 10
different spreadsheets?
Thanks!!
 

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

Use a master workbook to carry over changes to multiple workbooks 1
Splitting data from sheets into seperate workbooks based on formul 1
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
How to 'split' data from 1 column into 2?? 6
combining data from multiple workbooks 5
Compile data from several workbooks 1
Combine date from multiple Workbooks into one worksheet 2
Multiple Tables and Multiple Pivot Tables Help 0

Top