Sending only part of a workbook thru emai
I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .
My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl
|