K
Kim Cassell
I have inserted subtotals into a worksheet and used the pagebrea
feature so that each subtotaled group is located on it's own page. Fo
instance: Dept:1000 Page 1 / Dept:1001 Page 2 Dept:1002 Page 3
Etc..
Is there a way to save each page within a worksheet as a separat
document? What I am trying to do is to send each of my department
their own report (dept) by e-mail without manually copying and pastin
each and every one of them. I would like to set up a macro to do thi
but because the length of data within each dept changes each time...
can't use the copy/paste function.
Thank
feature so that each subtotaled group is located on it's own page. Fo
instance: Dept:1000 Page 1 / Dept:1001 Page 2 Dept:1002 Page 3
Etc..
Is there a way to save each page within a worksheet as a separat
document? What I am trying to do is to send each of my department
their own report (dept) by e-mail without manually copying and pastin
each and every one of them. I would like to set up a macro to do thi
but because the length of data within each dept changes each time...
can't use the copy/paste function.
Thank