Thread: How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default How could I split a spreadsheet containing 600 rows, so there's100 rows in each new workbook
Why split em up when you can simply use
datafilterautofilter

On Jan 25, 10:50*am, John wrote:
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!

Reply With QuoteReply With Quote