I would like to truncate the data between the subtotals when sending an email
with the subtotal data.

Excel will summarize the subtotals in one page however when I send an email
with this data highlighted, it also includes all the data in between.

Please let me know if there is a way to do this using VBA. What I have done
in the past is to copy the data and paste it to Notepad and then copy the
subtotals off the notepad and send the date via email.

You have one response to your earlier post.

tomwashere2 wrote:

I would like to truncate the data between the subtotals when sending an email
with the subtotal data.

Excel will summarize the subtotals in one page however when I send an email
with this data highlighted, it also includes all the data in between.

Please let me know if there is a way to do this using VBA. What I have done
in the past is to copy the data and paste it to Notepad and then copy the
subtotals off the notepad and send the date via email.

--

Dave Peterson