View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
maryjom maryjom is offline
external usenet poster
 
Posts: 2
Default 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,