Excel does not have records. Do you mean rows?

"maryjom" wrote in message
...
I have an Excel worksheet with roughly 5000 records in it. I want to
create
new worksheets with 100 records per worksheet. Is there an easy way to do
this other than cutting and pasting?

Thanks,