View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl43m carl43m is offline
external usenet poster
 
Posts: 22
Default 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