E-mailing Master Summary only

[Sharon]

I have created a workbook with about 15 sheets. I then have a Master sheet
which summarizes the information. I don’t want to e-mail all the sheets,
just the summary but when I delete the other sheets from the workbooks, it,
of course, loses the information and displays the #REF# error. I know I can
pdf the Master, but would really like to send it in Excel.

 

[Ron de Bruin]

Hi Sharon

You can install my mail add-in and use the values option
http://www.rondebruin.nl/mail/add-in.htm

 

[CLR]

When ready........Copy > PasteSpecial > Values of the Master Sheet to another
workbook. Then you can email that workbook.

Vaya con Dios,
Chuck, CABGx3

 

[Sharon]

Worked like a charm, but I sent you an e-mail message when I tested it!
Thanks.