Copying only the numerical values

  • Thread starter Thread starter SM
  • Start date Start date
S

SM

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.
 
SM said:
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.
Click to expand...

Ignore this - I just copied the page and used paste special.
Don't I feel a fool knowing how simple it was.
 
So how do you copy just the numerical values?

SM said:
Ignore this - I just copied the page and used paste special.
Don't I feel a fool knowing how simple it was.
Click to expand...
 
Back
Top