Data from another worksheet

T

Tomvernc

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
Top