Copying only the numerical values
 

Is it possible to have a summary worksheet in an Excel spreadsheet and then
copy this worksheet on its own to another document but with the numerical
values only?

I have a worksheet which is a summary of various other Excel documents
linked together. I wish to email this summary page with the numerical values
only. I don't particularly want the file paths showing in the document I
email - I just wish the numerical values - not the formulas which produce
these values. Is this possible? Without going through complicated
procedures.

Copying only the numerical values
 

"SM" wrote in message
...
Is it possible to have a summary worksheet in an Excel spreadsheet and
then copy this worksheet on its own to another document but with the
numerical values only?

I have a worksheet which is a summary of various other Excel documents
linked together. I wish to email this summary page with the numerical
values only. I don't particularly want the file paths showing in the
document I email - I just wish the numerical values - not the formulas
which produce these values. Is this possible? Without going through
complicated procedures.


Ignore this - I just copied the page and used paste special.
Don't I feel a fool knowing how simple it was.

Copying only the numerical values
 

So how do you copy just the numerical values?

"SM" wrote in message
...

"SM" wrote in message
...
Is it possible to have a summary worksheet in an Excel spreadsheet and
then copy this worksheet on its own to another document but with the
numerical values only?

I have a worksheet which is a summary of various other Excel documents
linked together. I wish to email this summary page with the numerical
values only. I don't particularly want the file paths showing in the
document I email - I just wish the numerical values - not the formulas
which produce these values. Is this possible? Without going through
complicated procedures.


Ignore this - I just copied the page and used paste special.
Don't I feel a fool knowing how simple it was.