Creating smaller files from one worksheet
 

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,

Creating smaller files from one worksheet
 

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,

Creating smaller files from one worksheet
 

Yes.

"Tyro" wrote:

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,