ExcelBanter - How to Split the table and keep the header on each portion.

In the next free column, enter this formula:

=ROW()-1

and copy down - it will give you a simple sequence 1, 2, 3, 4 etc,
assuming your data starts on row 2. Apply Autofilter to this column,
and from the filter drop-down select Custom and then choose Less than
or equal to and enter 2400. You can now select all the visible cells
including the header row and <copy and paste them into a new
worksheet.

For your next batch you should choose Custom from the Filter drop-down
and choose two conditions:

Greater than 2400
And
Less than or equal to 4800

Again, highlight the visible cells including the header and copy/paste
into a new sheet. Keep doing this until you are finished, adjusting
the range of numbers as appropriate.

Finally, you can delete the original sheet and use File | Save As to
give the file a different name.

Hope this helps.

Pete

On Jul 30, 9:28*am, capxc wrote:
We would like to split the spread**** in even portions of 2400 *rows and keep
the header on each of them. How can this be done?
And, after it is done, can those portions be saved separately?
--
capxc