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.
|