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
