View Single Post
  #1   Report Post  
Tere Gardner
 
Posts: n/a
Default printing - creating new files on each page break

I have a file with results from various departments/divisions in the company.
Is there any way to have each page break create a new worksheet? I have to
email each dept/div to the proper manager. There a many, many depts/div and
it takes a long time to do this each week.

thanks,
--
Tere for Stan