Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split data from 1 workbook into multiple workbooks based on criter
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying rows from 2 sheets to a new worksheet based on date criter | Excel Discussion (Misc queries) | |||
Trying to use INDEX and MATCH to insert a value w/ multiple criter | Excel Worksheet Functions | |||
Formula Help - Copy data from one sheet to another based on criter | Excel Worksheet Functions | |||
How to create reports based on data residing in multiple workbooks | Excel Discussion (Misc queries) | |||
Can I split worksheets from one workbook into individual workbooks | Excel Discussion (Misc queries) |