View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
SM SM is offline
external usenet poster
 
Posts: 7
Default 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.