| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook
Suppose a spreadsheet contains 600 rows of data.
I'd love to be split this into separate workbooks containing 100 rows each. - I'd like the name format to be gubbins1.xls, gubbins2.xls, gubbins3.xls, gubbins4.xls, gubbins5.xls, gubbins6.xls - I'd like each workbook to keep row 1 of the original file (because it's a header row) ------ Notes - I really want the output to be Excel spreadsheets (XLS etc), rather than CSV - Thanks for taking the time to read this! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to split the spreadsheet, not the screen | Excel Discussion (Misc queries) | |||
| Split up spreadsheet by sales rep | Excel Discussion (Misc queries) | |||
| How to split up one spreadsheet into multiple worksheets | Excel Discussion (Misc queries) | |||
| how do i split an excel spreadsheet into 6 panes? | Excel Worksheet Functions | |||
| Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) | |||
![John[_147_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
