Select the range..Copy..
New workbook..
Right click|PasteSpecial|Values|OK

If this post helps click Yes
---------------
Jacob Skaria


"Tomvernc" wrote:

I have a summary sheet as part of a workbook. Some of the data contained is
obtained by reference to another sheet. I would like to send the summary
sheet with the data values resolved to another user without having to send
the complete workbook as it contains sensitive personal information.
Is there a way to achieve this please?

Tom